Drop Downs



I am trying to create a Drop Down tab. I would like to see a cell with an
arrow pointing down, and when I click on that arrow, a list drops down. I
tried creating this drop down through Data, Validation, List. The list I
want is created, but there is no arrow next to the list to show me that this
is actually a drop down cell. Right now you can not see that this cell is a
drop down cell unless if you click on it. So my question is, how can I
create an arrow pointing down in a Data Validation List to inform people that
they can click the cell and select different options. What is selected does
not actually change anything in the excel file, just an indication.

side question... Also, is there a keyboard shortcut for the Format Painter?




Simple answer 1 = ask in the excel form (this is for access databases)
Simple answer 2 = most excels do not show the drop down until they have the
focus - this is normal you - can format one - but whats the point?

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