Detecting invalid data in cells

<< Click to Display Table of Contents >>

Detecting invalid data in cells

The command group Review | Input validation provides, amongst others, commands that can be used to detect cells that contain invalid data.

Note: A cell contains invalid data if the command Input validation input_val_icon has been used to specify which values should be allowed in the cell, and the current cell content violates any of these rules. For more information, see Input validation.

To find such errors, use the following commands in the command group Review | Input validation:

input_val_group

invalid_mark_data_icon Mark invalid data

This command paints a red circle around each cell (on the current worksheet) that contains an invalid value.

invalid_remove_marks_icon Remove (invalid data) marks

Removes all red circles (from the current worksheet) added with the above command.

invalid_previous_icon Previous invalid cell

Jumps to the previous cell that contains an invalid value.

invalid_next_icon Next invalid cell

Jumps to the next cell that contains an invalid value.

Notes

The marks for invalid data also appear in the printout.

However, the marks are not stored in the document. Thus, when you save a document, close it and open it again, all circles are removed.