can you lock a list button in an excel spreadsheet?

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

 

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