Drop Down Menu

  • Thread starter Thread starter nicole
  • Start date Start date
N

nicole

How do I create a drop down menu in a particular cell. I want the menu
to contain alternate date the user can click on and it will
automatically enter the cell once clicked.

Thanks.
 
1. Select the cell on the spreadsheet,
2. Then from the menu bar DATA > VALIDATION
3. In the SETTINGS tab, use the scroll down beside "Allow:"
4. choose "List"
5. Enter in the options you wish to give the user either as values separated
by commas or as a cell reference.
6. Done!

Regards,
Nabiji
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking choices in drop down menu to have automatic answer... 3
Copying a Drop Down Menu 2
So very confused about drop down menus. 1
Selective Validation 4
Creating drop downs in a cell contingent on another drop down 1
drop down menue and autofills 4
referencing drop down menu values in IF-then statements? 4
How do I use different colours in drop down menus in Excel 2003? 4

Back
Top