can you lock a list button in an excel spreadsheet?
 

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?

can you lock a list button in an excel spreadsheet?
 

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