| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
drop-down list icon
Is there a way make the drop-down list icon (from Data-Validation) remain
visible without selecting the cell; in the same manner a combo box can always be seen? Thanks, Iyue |
|
#2
|
|||
|
|||
|
No, 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. Iyue wrote: Is there a way make the drop-down list icon (from Data-Validation) remain visible without selecting the cell; in the same manner a combo box can always be seen? Thanks, Iyue -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
| Drop Down List | Excel Worksheet Functions | |||
| Drop List Referencing | Excel Worksheet Functions | |||
Linear Mode
