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

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.

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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Slater" wrote in message
...
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.