In this post we will be setting a maximum input value for cells within an Excel spreadsheet. To achieve this we will use a data validation function to restrict the type of data or the values that users enter into a cell. In this example we will be setting the maximum input value for a cell to 100. This means if a user were to enter a value greater than 100, an error message will appear.
To set the maximum input value for cells within an Excel spreadsheet carry out the steps below.
- Start by highlighting the cells that you are wanting a maximum input applied to.
- With the cells selected click on the ‘Data’ tab along the top and then click ‘Data Validation…’ within the ribbon.
- A new window will appear, within the ‘Allow’ dropdown select ‘Whole Number’.
- Within the ‘Data’ dropdown select ‘Less than’ and then enter in a maximum value. In our example the maximum value is ‘100’. Once done click ‘OK’.
This will apply the data validation across all the highlighted cells. Should the user enter in a number above ‘100’ an error message as seen below appears. If you found this useful take a look at some of our other content around Microsoft Excel by clicking here.