Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Drop Down Box

Status
Not open for further replies.
jdanner24

jdanner24

Technical User
Nov 13, 2003
4
US
Can someone please explain how to make a Drop down box in Excel step by step.

Thanks
JDANNER24
 
Sort by date Sort by votes
The most basic way
Follow menu path
Data>Validation

choose List and enter your list entries seperated by commas

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Question
Excel Webservice
Replies
2
Views
286
mintjulep
M
pendle666
  • Locked
  • Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
296
combo
combo
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
599
renigar
renigar
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
513
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
432
combo
combo

Part and Inventory Search

Sponsor

Back
Top