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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
lists

ResolvedVersion 2003

Teresa has attended:
Excel Intermediate course
Excel Advanced course

Lists

How do you do a drop down list?

RE: Lists

Hi Teresa,

Thank you for your question.

To create a drop down list you use Data Validation which is accessible via the Tools menu. Choose Allow list and then type the values into the Source box separated by commas.

Alternatively, you can use the control toolbox to create a combo box and then write Visual Basic code to create the value list.

I hope this answers your question.

Regards

Simon

Mon 26 Jan 2009: Automatically marked as resolved.

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.