Creating a dropdown list within a column
 

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.

Creating a dropdown list within a column
 

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.


"dsebiz" wrote:

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.

Creating a dropdown list within a column
 

Watch this 5 min video:

http://youtube.com/watch?v=t2OsWJijrOM


--
Biff
Microsoft Excel MVP


"dsebiz" wrote in message
...
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.

Creating a dropdown list within a column
 

Thank you for the information - it resolved my issue!

"Tara @ Fuinneoga Computer Training" wrote:

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.


"dsebiz" wrote:

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.

Creating a dropdown list within a column
 

Delighted I could help!!

"dsebiz" wrote:

Thank you for the information - it resolved my issue!

"Tara @ Fuinneoga Computer Training" wrote:

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.


"dsebiz" wrote:

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.