Creating a dropdown list within a column

D

dsebiz

I have an existing XLS file with a column that is currently manually
populated. However, I would like to create a dropdown list for my end users
so they can choose a value from the dropdown list to populate this specific
field. However, I can't seem to find how to go about creating one in Excel -
any help would be appreciated.
 
T

Tara @ Fuinneoga Computer Training

Click into the cell you wish to display your drop down list in. To create a
drop down list got to Data and Validation.

In the settings tab under Validation Criteria choose List from the Allow
box. Make sure the Ignore blank and In-cell dropdown boxes to the right are
ticked.

In source highlight the range of cells you wish to use, these will be
automatically Absoluted by the program.

If you wish to apply this list to more than one cell with the same settings
make sure to tick the box.

Click OK

Your drop down arrow will appear to the right of the cell. Just click the
arrow to open the menu and choose the appropriate item from the list.

I hope this solves your problem.
 

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

Help With MS Access 4
Displaying arrow in a dropdown list within cell 2
Combo Box / Dropdown Box HELP!!!! 3
Dropdown List 10
How can I use conditional formating in dropdown using named list? 1
Creating a dropdown list based on selection from a differernt drop 5
Data validation with dropdown list 2
Need to have a dropdown list or allow other entry? 1

Top