Cloud Training (Online)

How to limit entries to numeric value in Microsoft Excel ?

There are times when you might want to control what data the user can enter to a cell. For example , you want the user to enter only a numeric value that is greater than 75.

How to limit entries to numeric value in Microsoft Excel ?

You can do this easily in Excel using the Data Validation.

1. Open your workbook in Microsoft Excel and select the range of cells that you want to limit to the numeric value greater than 75.

2. Click Data Tab and then choose –> Data Validation –> Data Validation


3. In the Data Validation dialog , select the “Settings” tab and then select the following and then click OK button.

“Whole number” in the “Allow” drop-down list.

“greater than or equal to” from the Data drop-down list.

Enter the value 75 from the Minimum value.


Now , try entering invalid values in the selected columns , you should see a error message displayed to the user stating “This value doesn’t match the data validation restrictions defined for this cell”.


Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.