Diagnosis: How to Discover Cells With Data Validation In Excel Using ALT + HFDV

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


Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *