Data Validation Excel 2016. Data validation in excel is a useful feature that allows you to control the type of data that is going into the spreadsheet. In addition you can create messages that will tell users what type of data should be entered into a specified cell then provide instructions for correct input.
After applying data validation if you want apply same data validation in. Dynamic data validation lists explained. If the validation command is unavailable the sheet might be protected or the workbook may be shared.
Select the cells where you want to restrict data entry.
Choose data tab data tools data validation. Select the cells where you want to restrict data entry. This data validation in excel tutorial is suitable for users of excel 2013 2016 2019 and word for microsoft 365. If the validation command is unavailable the sheet might be protected or the workbook may be shared.
