Making Drop Down Lists Using Excel. The Keyword Is “Data Validation Lists”

To avoid entering incorrect product codes, account names, surnames…

To limit options to a pre-populated list try creating a Data Validation List using Excel. In a separate sheet create a list of the data to display in the drop down, for example a list of department names or product descriptions. You might like to then hide the sheet by right mouse clicking on the sheet name and selecting hide. 

  • Excel-Computer-Courses-Sydney
  • Excel-Computer-Courses-Sydney
  1. Type a list of States
  2. Select the cell/s where you want the drop down list to display
  3. Go to the Data Tab, Data tools group
  4. Select Data Validation
  5. In the Allow field
  6. Choose List form the drop down arrow
  7. In the Source Field
  8. Select the range of cells with the States
  9. If you have given the States a Range name then Press = and type the range name or Press F3 and select from the list
  10. You know have a drop down arrow to select a state for your data entry.

Microsoft Office Small Group Training Sessions

AZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. We come to you. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. In our training sessions you are welcomed to bring examples of your work to class. We prefer it.

Call Now M 0414 417 059 visit

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s