Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Tip

When

Option A makes available all three validation methods listed below; Option B makes the first two available.

 

Tip

A data description for the column is displayed when you hover the mouse over a cell or click in a cell, a data description for the column is displayedUse Review this feature description if you are unsure of why a cell failed validation.

 

Option A makes available all three validation methods listed below; Option B makes the first two available.

Validation During Data Entry

...

  1. When you save the file, the program asks whether you would like to validate the file first.

  2. If you choose Yes, cells which do not pass validation will be displayed with a pink background.

  3. Find and correct the highlighted cells.

 

...

Validation Using the Validate Menu Item (Option A only)

  1. At any time you can validate the data you have entered by clicking the Validate menu item.

  2. If there are errors, the program displays a dialog with the error count and highlights all cells.

  3. Find and correct the highlighted cells. 

...