Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

2002 excel microsoft training - Drop down menu list

Resolved · Low Priority · Version Standard

Reply Thu 13 Dec 2007, 17:14Delegate Patricia said...

Patricia has attended:
Excel Intermediate course
Excel Advanced course

Drop down menu list

How do you create one in a work sheet?

For upcoming training course dates see: Pricing & availability

Reply Mon 17 Dec 2007, 11:14Trainer Sandy said...

RE: Drop down menu list

Hi Patricia

It was great to meet you on Thursday and Friday of last week on my Excel Intermediate and Advanced courses. Hope you had a great weekend!

How do we create a drop down menu list?

1. Select Data menu, Validation
2. Choose the validation criteria of List
3. Type in the Source box: the list for your drop down, separating each one by a comma.
4. Set up Input Message and Error Alert if required.
5. Click OK - Validation now set up.

Hope this helps
Sandy

Excel articles

· Discover How To Use Fill In Excel
· Finding Your Way Around Excel 2007
· How To Print Worksheets In Excel
· The Secret Formula To Creating Correct Calculations In Excel
· Advanced level training: Microsoft Excel and the Web

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips