Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When creating a drop down list in a spreadsheet, is there any way possible to
keep the drop down arrow button visible even though you aren't on the cell that the list is in? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not if you use Data|Validation.
I shade the cells that use this to make them stand out. You could add a shape from the drawing toolbar if you really wanted something, but I wouldn't. Or you could use a combobox from the control toolbox toolbar--or a dropdown from the Forms toolbar. Pittsburgh_Dante wrote: When creating a drop down list in a spreadsheet, is there any way possible to keep the drop down arrow button visible even though you aren't on the cell that the list is in? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I lock some of the worksheets in an excel 07 spreadsheet | Excel Worksheet Functions | |||
lock position of Word object in protected excel spreadsheet | Excel Worksheet Functions | |||
lock position of Word object in protected excel spreadsheet | Excel Discussion (Misc queries) | |||
How can I lock the gridlines in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) |