microsoft excel training - drop down menus

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Drop down menus

microsoft excel training - Drop down menus

resolvedResolved · Low Priority · Version Standard

Alicia has attended:
Excel Introduction course

Drop down menus

How to implement drop down menus

RE: Drop down menus

Alicia,

Drop down menus are known as Data Validation

Under TOOLS > DATA VALIDATION, there is an option called LIST. You need to specify what you will see in the list, by adding information to the SOURCE area. Separate the data with commas:

example:
Apples, Bananas, Pears

You can also select a range from the current speadsheet, by simply highlighting the data in a single column that you want to appear in the list.

Data validation LIMITS the information that you can enter into the cells by the criteria you specify, in this case the data or list that you enter.

Regards

Richard


 

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


Server loaded in 0.1 secs.