How to create an optional list for a cell

  • Thread starter Thread starter Ryan Hubbard
  • Start date Start date
R

Ryan Hubbard

I would like to create a list for a cell in excel that is optional.
The list is only a convience for the user but it does not define all
possible values that can be entered. Does anyone know how to do this?
I used validation but then that restricts the cells values to the
list values which I don't won't.


Thanks
Ryan
 
In the Data Validation dialog box, on the Error Alert tab, remove the
check mark from 'Show error alert after invalid data is entered'

Users will still see the dropdown list, but can type values that aren't
in the list.
 
Back
Top