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

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
Link a text box based on drop down box with four options MS Word 365 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Filtered drop down list 2
Using Drop Down list to an If Statement to another Drop Down list 3
Help with drop down selection and populating related data... 9

Top