Data Validation in Excel, How to restrict type of Data that user can enter into cells.

Posted on by

Excel can restrict data entry to certain cells by using data validation, prompt users to enter valid data when a cell is selected, and display an error message when a user enters invalid data.

Select the cell you want to validate. Go to the Data tab > Data tools, and click on the Data Validation button.

Use data validation to restrict the type of data or the values that users enter into a cell. One of the most common data validation uses is to create a drop-down list