Flags the cell and enables error correction for cells that contain formulas or values that are inconsistent with the column formula for tables.
First, specify the ranges. Type or select a worksheet range that contains data you want to summarize, and then click Add. ...
Flags formulas as inconsistent when they do not follow the same pattern as the formulas in adjoining cells. For example, ...
Flags the cell and enables error correction for cells that contain dates in text form that lack four digit dates such as ...
Flags the cell and enables error correction for cells that contain dates in text form that lack four digit dates such as ...
Flags the cell and enables error correction for cells that contain formulas or values that are inconsistent with the column ...
Flags the cell and enables error correction for cells that contain numbers that are stored as their textual representation, ...
Flags the cell and enables error correction for unlocked and editable cells that contain formulas, even in cases where the ...
For a quicker way to name a range, first select the range, and then type the name into the box to the left of the formula ...
For help with choosing the right function and filling in its arguments, click the Edit Formula button (the = button) on the ...