Microsoft Office Tutorials and References
In Depth Information
Correcting Errors
EX 63
Click Maximum on the shortcut
menu to display the Maximum
value in the range B6:F6 in the
AutoCalculate area of the
status bar.
range is
Click anywhere on the worksheet to
cause the shortcut menu to
disappear (Figure 1–93).
Right-click the AutoCalculate
area and then click Maximum on
the shortcut menu to cause the
Maximum value to no longer
appear in the AutoCalculate area.
AutoCalculate area
displays maximum
value in range
B6:F6 (92,716.32)
Figure 1–93
Correcting Errors
You can correct errors on a worksheet using one of several methods. The method you
choose will depend on the extent of the error and whether you notice it while typing the
data or after you have entered the incorrect data into the cell.
Correcting Errors while You Are Typing Data into a Cell
If you notice an error while you are typing data into a cell, press the BACKSPACE
key to erase the incorrect characters and then type the correct characters. If the error is a
major one, click the Cancel box in the formula bar or press the ESC key to erase the entire
entry and then reenter the data from the beginning.
Correcting Errors after Entering Data into a Cell
If you fi nd an error in the worksheet after entering the data, you can correct the
error in one of two ways:
1. If the entry is short, select the cell, retype the entry correctly, and then click the
Enter box or press the ENTER key. The new entry will replace the old entry.
2. If the entry in the cell is long and the errors are minor, using Edit mode may be a
better choice than retyping the cell entry. Use the Edit mode as described below.
a. Double-click the cell containing the error to switch Excel to Edit mode. In
Edit mode , Excel displays the active cell entry in the formula bar and a fl ashing
Search JabSto ::

Custom Search