Data Validation Excel 2016. You cannot change data validation settings if your workbook is shared or your sheet is protected. Data validation in excel 2016 data validation in excel allows you to define what type of data should be entered into a cell and allows you to prevent invalid data from being entered.
On the data tab under tools click validate. Excel displays the data validation dialog box which have 3 tabs a. This is why data validation rules are invaluable.
Select the cells where you want to restrict data entry.
You cannot change data validation settings if your workbook is shared or your sheet is protected. Create a data validation drop down list that dynamically updates when new items are added. This is why data validation rules are invaluable. This data validation in excel tutorial is suitable for users of excel 2013 2016 2019 and word for microsoft 365.
