MrExcel Publishing
Your One Stop for Excel Tips & Solutions

drop-down menu for a cell

Posted by Rich in San Diego on August 31, 2001 12:27 PM

Is there a way to create a drop down menu for a particular cell? Say for a fixed set of numbers? I know you can "pick from list" of names in a cell's column but I am looking to click a custom drop down menu that would appear next to a cell that would allow me to select from a specified list of numbers.
Thanks for your help!

Posted by Poor in Denver on August 31, 2001 12:32 PM

First type in the numbers you want to allow in a set of cells that can be hidden.
Go to the cell you want to input these values into and select valadation from the data menu.
Change allow to list
Go to the source box and highlight your list.
You can also add some error and input messages here.
Make sure the In-cell drop down box is checked and hit okay.

One caveat, a user can still enter any number they want by pasting, but they will only be able select your numbers if typing or using the drop down.

good luck

Posted by Barry Katcher on August 31, 2001 1:40 PM

You don't even need to type the numbers in a hidden cell. Just click on Data-Validation and, in the "Source" box, enter your numbers and/or letters, WITH A COMMA BETWEEN THEM. No spaces.