Only the active cell can have the data validation arrow visible.
Perhaps you could colour the cells to highlight them, or add comments to
the cells to mark them.
coal_miner wrote:
Greetings. First off, let me thank anyone in advance for taking the time to
assist me. My question should be easy to answer. I have setup some drop
down lists in one of my worksheets. The button with the arrow that opens the
list hides itself after I click on another cell. How can I keep that button
always showing? Thanks again. Cheers.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html