Thread: Drop-down for States
View Single Post
 
Old 06-21-2023, 06:22 AM
Karen615 Karen615 is offline Windows 7 64bit Office 2010 64bit
Competent Performer
  
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default Drop-down for States
Hello,

Is it possible to set up a drop-down for all 50 states? When the user opens the drop-down they can see (for example) New York-NY, California-CA, etc Then when a state is chosen, only the 2-character state is entered into the cell.

Your help is greatly appreciated.

Thank you,
Karen


Using Excel 365
Reply With Quote