Link to home
Start Free TrialLog in
Avatar of cliffordgormley
cliffordgormleyFlag for United States of America

asked on

Excel 2007 Remove Restrictions on a cell

Excel 2007.
When I try to enter a value of '0' in a cell, I get the following message:
"The value you entered is not valid.  A user has restricted what can be entered into this cell."

I want to remove this restriction (I did it awhile ago, but forgot how to do it).
Avatar of jlindler
jlindler

Got to the Review tab.   Click Protect Sheet.   Remove the check in the box Protect worksheet and contents of locked cells.  Click ok.

If they have entered a password, you will need the password to remove the protection.
ASKER CERTIFIED SOLUTION
Avatar of piji
piji
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial