Add shortcut to drop down pick list

G

Guest

I have a drop down pick list that has numerous entries of Cities in a
worksheet. Is there away to add shortcuts to the drop down pick list?

Thanks,
 
J

JW

Select the cell containing the validation list. Go to Data|
Validation. On the Setting tab, the Allow field should say List.
Look in the Source field. That will tell you the location of the
values that are appearing in the dropdown list. Go to that location
and add whatever you need to. You may need to extend the source to
pick up the newly entered data. Also, the Source could appear as a
named range. If so, copy the name of the range, close the dialog box,
press Ctrl+G, and paste the name into the
reference field of the dialog box. Click OK.
 

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

Data-Validation -List - Pick from a drop down menu 4
Drop down list 2
Excel Drop Down List 3
DROP DOWN LIST 3
Filtered drop down list 2
multiple data validation lookups 3
Creating a Drop down list then linking another cell. 1
Pick List - Shorten KeyStrokes 1

Top