Data Validation Excel 2016. This is why data validation rules are invaluable. How to use data validation in excel 2016 select the cells or range where you want apply data validation.
Create a data validation drop down list that dynamically updates when new items are added. In excel 2016 you need to establish data validation rules because by nature people are prone to enter data incorrectly because the task of entering data is so dull. If the validation command is unavailable the sheet might be protected or the workbook may be shared.
This is why data validation rules are invaluable.
Select the cells where you want to restrict data entry. Choose data tab data tools data validation. A data validation rule is a rule concerning what kind of data can be entered in a cell. You cannot change data validation settings if your workbook is shared or your sheet is protected.
