View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default restricted values error message

Sounds like the cells have data validation applied. To check for that:

Select one of those cells
Goto the menu DataValidation
See any settings there?

--
Biff
Microsoft Excel MVP


"Recordhop" wrote in message
...
I was given a spreadsheet to fill in. All cells are unprotected, but when
I
try to enter a number in the data cells, it says that I can't because the
cell has "restricted values". The values for the cells are noted as 1-5.
Entering those numbers, I get the error message, when I don't think I
should.

How can I "unrestrict" the restricted values?