pull down menu in a cell

Ryan M

New Member
Joined
Oct 19, 2002
Messages
2
I would like to know how I can create a pull down menu in a cell to enable multiple choices. Also I'd like to know how to edit these choices.

Many thanks.
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Paul B

Well-known Member
Joined
Feb 15, 2002
Messages
575
from the Excel help file, is this what you need?
Restrict cell entries to the data from a list

1 On the same worksheet, type the list of valid entries down a single column or across a single row. Do not include blank cells in the list.
2 Select the cells that you want to restrict.
3 On the Data menu, click Validation, and then click the Settings tab.

Show me

4 In the Allow box, click List.
5 In the Source box, enter a reference to your list of valid data.

If you want to select from a list of the entries when you click a restricted cell, make sure the In-cell dropdown check box is selected.

To specify that the entry is not valid if the restricted cells or the cells that contain your list of valid data are blank, clear the Ignore blank check box.

6 To display messages to prompt for entries and to explain or prevent incorrect entries, specify the types of messages you want on the Input Message and Error Alert tabs.

How?

To omit display of messages, clear the Show input message when cell is selected check box on the Input Message tab, and clear the Show error alert after invalid data is entered check box on the Error Alert tab.

Tips

· If the list of valid entries is short, you can type them in the Source box instead of typing the entries on a worksheet, separated by the Windows list separator character (commas by default). For example, you could type Low, Average, High in the Source box instead of entering the three words on a worksheet.
· If the list of valid entries might change, name the list range, and then enter the name in the Source box. When the named range grows or shrinks because of changes you make to the list on the worksheet, the list of valid entries for the cell automatically reflects the changes.

· If the list of valid entries is in another worksheet or workbook, define a name for the external data on the active worksheet. In the Source box, you can then refer to the name on the same worksheet. For example, if the data you want to use in a formula is in cells A6:A12 on the first worksheet in a workbook named Budget.xls, you could define the name ValidData on the active worksheet to be =[Budget.xls]Sheet1!$A$6:$A$12 and then enter =ValidData in the Source box. For information about defining names, click .
 

Forum statistics

Threads
1,143,702
Messages
5,720,375
Members
422,281
Latest member
jantoooh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top