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

Solution

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

Insert New Column/Row in Microsoft Excel using Keyboard Shortcut
Delete Internet Explorer Browsing History on Exit
Adjust Internet Explorer Tabs Position
Disable "Use recommended security and compatibility settings" Internet Explorer
© 2017 ITsiti. All Rights Reserved
Powered by KEEM