Microsoft Office Tutorials and References
In Depth Information
• Click Maximum on the shortcut
menu to display the Maximum
value in the range B6:F6 in the
AutoCalculate area of the
• 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.
value in range
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 ﬁ 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 ﬂ ashing