How do I show that a drop down list exists in a cell?

B

Bob Slater

I have a data sheet that I want sales reps to fill out, I have provided them
with drop down lists to select dates and product information. When I open the
sheet the fields with the drop down boxes just look like every other cell on
the sheet. Is there a way to flag the cell to indicate that they contain a
drop down list? Or at least show the arrow to indicate thar a drop down
exists.
 
R

RagDyer

Why not just apply a color to them?

Hit <F5> and click "Special".
Click on "Data Validation", then <OK>.

This selects all the DV cells.
Then, while they're *still* selected, just click on the "Fill Color" icon on
the tool bar, and choose a *nice* color.
 

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

Filtered drop down list 2
drop down list 2
Drop down list question 1
Making Drop Down Box Visible with Excel 2003 2
Data validation list using filtered range 3
How to Link drop-down list? 2
Excel Excel: How do I put a formula in a drop down list 11
Drop down list reference 1

Top