how to unrestrict access to a cell

  • Thread starter Thread starter rayado
  • Start date Start date
R

rayado

i have preset option to put on a cell .. and i need to put more options to
choose from .... its tell inme that is invalid .. how can i bypass that or
edit the options on that cell???
 
Data>Validation is where you find restrictions on cell entries.

Change the options and/or change the Error Alert to "Warning" and add a
message which allows any entry if user clicks OK to "continue".


Gord Dibben MS Excel MVP
 
Back
Top