Forum home » Delegate support and help forum » Microsoft Excel Training and help » How do I create drop-down lists in excell spreadsheets?

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

ResolvedVersion 2003

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

Alistair has attended:
Excel Intermediate course
Project Introduction course

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

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

Mon 29 Jun 2009, 13:11 Trainer 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

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

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

Thank you for a quick response.
A

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips

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

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

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

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

Excel articles

Excel tip:

Creating custom lists