lists

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Lists

Lists

resolvedResolved · Medium Priority · Version 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:

Display Formulas Instead of Results in Excel 2010

By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again.

A much quicker and simpler way of displaying your formulas!

View all Excel hints and tips


Server loaded in 0.08 secs.