can you lock a list button in an excel spreadsheet?

  • Thread starter Pittsburgh_Dante
  • Start date
P

Pittsburgh_Dante

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?
 
D

Dave Peterson

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.
 
Top