Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

drop down lists

ResolvedVersion Standard

Drop down lists

How do you create drop down lists in Excel?

RE: Drop down lists

Hi Karen,

Thanks for your question.

In order to create a drop down list:

    1. Select DATA menu > Validation
    2. In SETTINGS tab > choose under ALLOW > LIST
    3-1. In SOURCE box, type in your list of items with a comma as separator
    3-2. You can also select an exisiting list on the same worksheet
    4. Finally, press OK to confirm. You should see a drop down button to show the list



Regards,

Katie Woo
Microsoft Certified Trainer

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.