Drop down lists

The UK's most regular instructor-led training courses.
Training information: excel computer course london · Microsoft+excel+training · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Drop down lists

Karen has attended:
Project Intro Intermediate course
Excel Intermediate course

by - delegate Karen [2 posts] (2008 Feb 14 Thu, 15:42) Reply

How do you create drop down lists in Excel?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Drop down lists

by - trainer Katie gold contributer [202 posts] (2008 Feb 14 Thu, 16:12) Reply

Hi Karen,

Thanks for your question.

In order to create a drop down list:

Regards,

Katie Woo
Microsoft Certified Trainer

· Reasons Why VBA for Excel Training Fails
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· A Beginners Guide To Formulas In Excel
· Microsoft Excel Training - Numerical excellence for all
· Fun Things I've Done With Excel

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips