Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation - indirect function
Hi all
I have used the data|validation|use list|indirect function so I can choose various options from a chosen list, however, the drop down arrow only appears when the cell is selected. Is there any way you can set Excel so the drop-down arrows are permanently visible, even when the cell isn't selected? Thank you Louise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data validation - indirect function
AFAIK, you can't do that, but how about coloring the cell(s) to make them
stand out. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Louise" wrote in message ... Hi all I have used the data|validation|use list|indirect function so I can choose various options from a chosen list, however, the drop down arrow only appears when the cell is selected. Is there any way you can set Excel so the drop-down arrows are permanently visible, even when the cell isn't selected? Thank you Louise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidate data using 3d function AND indirect | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |