How do I create drop-down lists in excell spreadsheets?

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

Resolved · Urgent Priority · Version 2003

3 posts

ReplyMon 29 Jun 2009, 11:37Delegate Alistair said...

Alistair has attended:
Excel Intermediate course

How do I create drop-down lists in excell spreadsheets?

How do I create drop-down lists in excel spreadsheets?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	0	FULL
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	7		£445	£450
2007	Wed 28 + Thu 29 Apr 2010	Bloomsbury	6		£445	£450
Full Schedule: See all 35 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyMon 29 Jun 2009, 13:11Trainer Amanda said...

RE: How do I create drop-down lists in excell spreadsheets?

Hello Alistair

Thank you for your question and welcome to the forum.

To create dropdown lists, use data validation.

1. Select the cells to contain the dropdown list.
2. Go to Data - Validation
3. Select List
4. Enter each list item in the blank area near the bottom of the dialogue box, separated by commas, e.g. Monday,Tuesday,Wednesday etc.
5. Click OK.

I hope this helps.

Kind regards
Amanda

3 posts

ReplyMon 29 Jun 2009, 13:48Delegate Alistair said...

RE: How do I create drop-down lists in excell spreadsheets?

Thank you for a quick response.
A

· Utilise the web's information banks with Microsoft Excel
· How to Create Better Excel Spreadsheets: Part Four
· Which Is Better, Excel Or Access?
· Conditional Formatting in Excel 2007
· Microsoft Excel Courses Teach Advanced Macro Techniques

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

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips