LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show it here, if it exists there Kevin Excel Discussion (Misc queries) 5 July 28th 07 06:21 PM
Data Validation Drop Down List - Always Show Louise Excel Discussion (Misc queries) 1 September 18th 06 12:26 PM
Named Ranges don't show up in drop-down list hds Excel Discussion (Misc queries) 14 July 3rd 06 09:30 PM
How to Show Existing IE Instance if Already Exists, Else Open One Cole Excel Discussion (Misc queries) 0 June 9th 06 07:35 PM
How do you work with drop down list to show a name, diff payment? Drop down list Excel Worksheet Functions 1 July 1st 05 01:54 AM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"