Tech Support Guy banner

drop-down boxes for Excel

872 Views 2 Replies 3 Participants Last post by  Anne Troy
I need to know how to make drop-down boxes in Excel. I need to be able to choose from a list of about 250 different customer names in each cell. Please let me know if you know anything about creating drop-down boxes, or something similar in Excel.

Thank You
Status
Not open for further replies.
1 - 3 of 3 Posts
open excel
click on help
type drop in the search field
read

seriously, there's a ****load of options and possibilities depending on how you want to do it (and yes, all in the help file)

sounds like a database type of application better than excel
Put your list of customers in a column off to the right of your "form".

In the first cell where you want a dropdown, hit Data-Validation. Choose List. If your customer names are in cells K2 through K252, you can type:

=$K$2:$K$252

into the box, or you can click the icon at the right end of the box and select the list with the mouse. Once the list cells are selected, hit the icon again.

Hit Ok.
You'll need to copy this cell down as far as you want checkboxes to go.
This is the easiest way to use a dropdown box in Excel. There are two other ways.
1 - 3 of 3 Posts
Status
Not open for further replies.
Top