-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Drop down menu's - Picklists?
- Thread starter garymu16
- Start date
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
Welcome to the Board!
Sure. The easiest method is with Data Validation.
Type a list somewhere (it can be on a hidden sheet), then highlight it and goto Insert-->Name-->Define and name it.
Then goto the cell where you want the drop-down and goto Data-->Validation-->Allow-->List-->Source-->"=ListName" (no quotes).
Hope that helps,
Smitty
Sure. The easiest method is with Data Validation.
Type a list somewhere (it can be on a hidden sheet), then highlight it and goto Insert-->Name-->Define and name it.
Then goto the cell where you want the drop-down and goto Data-->Validation-->Allow-->List-->Source-->"=ListName" (no quotes).
Hope that helps,
Smitty
Upvote
0
