Flags the cell and enables error correction for cells that contain numbers that are stored as their textual representation, as opposed to as a number. For example, the values of 1 and "1" are different to Excel.
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 ...
For line charts only, you can click Preferences on the Edit menu, and then specify on the Chart tab whether you want blanks ...