Drop down box

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,026
I have a spread sheet that if you click into a cell an arrow pops out to the right of the cell allowing you to click on it and a list pops up for you to select an number from. The list that pops up is on another spread sheet. The problem is I can't remenber how I did and now I'm trying to do the same thing on another spread sheet. Could someone please refresh my memory.

Thanks
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Banker1

Active Member
Joined
Mar 10, 2005
Messages
463
You create the list on a seperate spreadsheet and name the range containing the list. Once you have the named range go to Data --> Validation and select List. In the Source box type =NamedRange (i.e. =Month).
 

Watch MrExcel Video

Forum statistics

Threads
1,118,320
Messages
5,571,531
Members
412,401
Latest member
allenayres83
Top