How to create an optional list for a cell

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
 
D

Debra Dalgleish

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