WINDOWS, WINDOWS SERVER

How to Remove Excel User Restriction Values in Excel File And Cell

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

Solution

First of all, let me tell you that whenever there is a restriction on the values, the flow is not without any amount. You should know here that the restriction on the values ​​is due to reasons. The author only wants you to enter the specific information / price and you should follow it.

But, if you want to know, please see below –

Go to the DATA tab and click on the restricted cell. Look for data validatioand click on it. Now, CLICK on Clear All and OK. This will remove the restrictions from the cell.

Leave a Reply

Your email address will not be published. Required fields are marked *