Excel Super Tip

Apply restriction on your input using Data Validation!

Suppose you are running a survey on a group of people aged between 30 to 40. To maintain their records you surely want some restriction on their age inputs. First their age should be a whole number and second it must be between 30 to 40.

Excel has a data validation function to impose such restrictions on your input. Let see how to do it:

Step #1: Select “Data” tab and choose “Validation”.

Step #2: In the validation window under Settings section select Allow as “whole number” and fill other details as per your requirement.

Step #3: Next shift to “Input message” and type your error message here.