Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show it here, if it exists there | Excel Discussion (Misc queries) | |||
Data Validation Drop Down List - Always Show | Excel Discussion (Misc queries) | |||
Named Ranges don't show up in drop-down list | Excel Discussion (Misc queries) | |||
How to Show Existing IE Instance if Already Exists, Else Open One | Excel Discussion (Misc queries) | |||
How do you work with drop down list to show a name, diff payment? | Excel Worksheet Functions |