Forum home » Delegate support and help forum » Microsoft Excel Training and help » Drop down menus

Drop down menus

ResolvedVersion 2003

Thu 15 Jan 2009, 15:55 Delegate Gillian said...

Gillian has attended:
Excel Intermediate course

Drop down menus

How can I create dropdown menus with options which have not already been entered into the spreadsheet?

Tue 27 Jan 2009, 13:39 Trainer Amanda said...

RE: Drop down menus

Hello Gillian

Thank you for your question and welcome to the forum.

You can create dropdown lists using Data Validation.

You will find an example and instructions on how to create a dropdown list here:
http://www.contextures.com/xlDataVal01.html #Create

Kind regards
Amanda

Tue 3 Feb 2009: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips

Drop down menus

Drop down menus

RE: Drop down menus

Excel articles

Excel tip:

No Zeros