Validating formula results in excel 2016

Rated 3.91/5 based on 780 customer reviews

By Peter Weverka 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. A data-validation rule is a rule concerning what kind of data can be entered in a cell.

When you select a cell that has been given a rule, an input message tells you what to enter, as shown here.

Data-validation rules are an excellent defense against sloppy data entry and that itchy feeling you get when you’re in the middle of an irksome task.

In a cell that records date entries, you can require dates to fall in a certain time frame.

In a cell that records text entries, you can choose an item from a list instead of typing it yourself.

I’m a manager at an engineering company, and I hired an out-of-work political science major to do data entry and other clerical stuff.

We don’t pay him a lot, but our deal is that he gets to learn about computers on our dime when he’s doing data entry.

Leave a Reply