I think this is not Possible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When using Data Validation in EXCEL 2003 and Choose to have your numbers in a
"List" such that when you highlight that cell a drop down menu will appear
does ANYONE know how to keep that drop down menu still there even when it is
not the active cell.

If you know you can post here or email me at (e-mail address removed)

Thanks.
 
If you use Data Validation to create a drop down list in a cell, the
arrow is only visible when the cell is active.

If you want arrows that remain visible at all times, you could use a
combo box from the Forms toolbar, or from the Control toolbox.

Or, you can colour code the cells with data validation, to guide your users.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CF 1
conditional formating for the whole row, based on one cell value 2
Copying a Drop Down Menu 2
Selective Validation 4
Multi layered drop down 1
Linking choices in drop down menu to have automatic answer... 3
Use word to associate an item in validation drop down list 2
Filtered drop down list 2

Back
Top