lists

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Lists

Lists

resolvedResolved · Low Priority · Version 2003

Rob has attended:
Excel Intermediate course
Outlook Advanced course

Lists

How do you create a drop down list?

RE: lists

Hello Rob

Thank you for your question and welcome to the forum.

You can create dropdown lists in Excel using a feature called data validation (Data menu - Validation option).

Firstly, select the cell/s you wish to have the dropdown list available in.

Then on the Settings tab, select List and then in the Source box, type each item separated by a comma and a space, e.g.
Sales, Marketing, Accounts

You can create further settings for the validation using the Input Error and Error Alert tabs if you wish, and then click OK.

Your dropdown list should appear on the cells you selected before setting up the validation.

Data validation and other useful topics are covered as part of our Excel Advanced course. Further information about the course including syllabus and dates can be found on the following page:
https://www.stl-training.co.uk/excel-training-in-london-2003-advanced.php

Amanda

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

View all Excel hints and tips


Server loaded in 0.08 secs.