Restricted Cell

[Jack-P-Winner]

I have downloaded a file and i need to put a digit in a cell but when I do it says that ot has been disabled by user. Hmm, how do I fix that? there are no protected sheets

 

[Debraj]

Hi Jack!

• Which cell you are talking about!!
• Did you unhide.. Column Q to AA in the sheet...
• Did you checked.. Which cell are having a Data Validation applied.

Please give your 100%.. we are here if you are missing something..

 

[Jack-P-Winner]

Thanks for replying Debra

The cells that say enter draw and enter next draw No I did not unhide those columns What are you thinking?

 

[NARAYANK991]

Hi Larry ,

The cells B1 and B2 have data validation dropdowns in them ; you can only select from the values in the list ; unhide column AA , and you can see the list of numbers which are possible. Of course these are not numeric values , but text.

Narayan

 

[Jack-P-Winner]

OMG ! Thanks AGAIN, Narayan....