Excel 2003: I need the Drop-Down List symbol to show all the time

  • Thread starter Thread starter Doingthat2
  • Start date Start date
D

Doingthat2

I created a list within Excel and when I select the cell I get the drop down
box which allows me to then select one of the item within the list.

My question is: How can I have the drop-down button show for the cell that
contains the list. As mentioned, currently it only shows when you select the
cell. You cannot tell there is a drop down list until you select the cell.
I would like people to know there is a drop down list available without
having to first select the cell.
 
You can use a comb box from the forms toolbar. The drop arrow is always
visible *but* a combo box works differently compared to a data validation
list. Or, continue to use the data validation list *but* highlight the cell
with a border or a background fill color so that it stands out.
 

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

Formatted cell column in drop down list 1
Drop down list 1
Excel Lists 4
Excel Excel: How do I put a formula in a drop down list 11
Drop down lists 6
Drop Down Lists 2
Drop Down Lists 2007 10
drop down list 3

Back
Top