Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Lists
Resolved · Medium Priority · Version 2003
Teresa has attended:
Excel Intermediate course
Excel Advanced course
How do you do a drop down list?
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:Display Formulas Instead of Results in Excel 2010By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again. |
We'll call during UK business hours
Server loaded in 0.08 secs.