Creating a dropdown list within a column

  • Thread starter Thread starter dsebiz
  • Start date Start date
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.
 
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.
 
Back
Top