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 Rhinorhino 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
Joined
Nov 13, 2003
Messages
4
Location
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

BxWill
  • Question Question
MS EXCEL 2016 LINE CHART NOT DROP TO ZERO - USING NESTED IF AND COUNTIF
Replies
1
Views
156
combo
combo
Swi
  • Locked
  • Question Question
Excel Webservice
Replies
2
Views
834
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
795
SkipVought
S
pendle666
  • Locked
  • Question Question
Excel - Quick Access Toolbar - customise with a drop-down menu
Replies
3
Views
750
combo
combo
Kim296
  • Locked
  • Question Question
Need Genius Help - Finding multiple duplicates between columns - EXCEL
2
Replies
38
Views
3K
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top