From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Locating data validation rules and violations

Locating data validation rules and violations - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Locating data validation rules and violations

- [Voiceover] Someone has just sent you an employee list, like the one we see here, and as you start to make certain entries and adjustments, you realize there are some problems that you can't quite figure out at first. And data validation rules which are in this worksheet in different locations at least initially might be hard to track down unless you know some of the techniques for getting there. Imagine I'm making a change to one of the employee IDs. I'm looking at a sheet of paper here, and this particular employee ID here begins with zero. So I'm double-clicking in this cell, D4. Put in a zero, I press Enter. I get a message. The value doesn't match the data validation restrictions. Not sure about that one. Come back to that later. The residency code for this first person here should be a six. Type a six, press Enter, and there's some restriction there that I don't know about preventing me from putting that in. Or I'm changing the compensation amount for this person, 133,000…

Contents