Skip navigation

Locating cells with data validation rules

Locating cells with data validation rules: Excel 2016: Data Validation in Depth
Locating cells with data validation rules: Excel 2016: Data Validation in Depth

After opening a file you've never used, you can be surprised by the presence of data validation rules. To scope them out, click the Home tab in the ribbon and then click Find&Select and then click Data Validation. All cell in the current worksheet with data validation rules in effect will be highlighted.

  • Overview
  • Transcript
  • View Offline
Resume Transcript Auto-Scroll
Skill Level Advanced
1h 34m
Duration
24,151
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now