How to Remove Excel User Restriction Values in Cell

Share this article :

You are getting below error message when entering words / numbers to the Microsoft Excel cell.

The value you entered is not valid
A user has restricted values that can be entered into this cell

Excel - User restricted values


First of all, you should aware that values restriction happen for reasons. The author might want you to only enter specific information / value and you should follow it.

But, if you are stubborn 🙂 , please try below –

Go to DATA tab and click on the restricted cell. Look for Data Validation and click on it. Now, click on Clear All and OK. It will remove the restrictions from the cell.

Remove Excel Cell Data Validation

Related posts

Enable URL Click-able in Microsoft Communicator 2007
How to Compare Between 2 Microsoft Word Documents
Enable / Disable Internet Explorer Automatic Crash Recovery
Error 1401: Could not create key
© 2018 ITsiti. All Rights Reserved
Powered by KEEM