how to unrestrict access to a cell

  • Follow


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???
0
Reply Utf 4/27/2010 11:41:01 PM

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

On Tue, 27 Apr 2010 16:41:01 -0700, rayado
<rayado@discussions.microsoft.com> wrote:

>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???

0
Reply Gord 4/27/2010 11:53:04 PM

1 Replies
2012 Views

(page loaded in 0.005 seconds)


Reply: