drop-down boxes for Excel

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

jkliebe

Thread Starter
Joined
Nov 6, 2001
Messages
1
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
 
Joined
Oct 29, 2001
Messages
2,056
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
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,755
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.
 
Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

No members online now.
Top