Excel - Data Validation Restricting Cell Entries

This and additional Hints can be found on our website - Training Materials

It is possible to restrict cells so that only certain values can be entered into them, by controlling what data is entered into a cell will make worksheets more reliable.

For example you may require a column to only accept numeric numbers for calculations, therefore you may wish an error message to be displayed if any other value is entered like text.

In the Example below we want to allow only a who number between 10 and 20 to be entered in column ‘A’.

Data Validation Building a Drop-Down List.

A drop-down list could contain a list of departments that you choose from, this way a user must select from the list not typing in the data manually causing errors, for example typing a department two different ways ‘HR’ or ‘Human resources’.