Welcome to Excel Jet Consult blog post. In this post we will learn how to perform diagnosis to discover cell with data validation in Excel.
Succinctly, Data Validation is a feature that enables users to control data that is entered in Excel. Data Validation is located in the Data Tools group of the Data tab
In the data caption below, we want to verify which cells has data validation
To do this using shortcut key: execute ALT + HFDV
In the caption below, data validation is applied to values in columns A, C, E and J
Task completed