Suppose that you have entered text or numbers into a cell and saved the entry by pressing Enter or clicking the check mark at the left edge of the Input Line. Suppose further that you now discover a mistake in that cell. You can correct the mistake in a couple of ways.
First, you can simply type over the information in the cell; select the cell, type, and save the entry by pressing Enter or clicking the check mark at the left edge of the Input Line. This technique works best when the information in the cell is relatively short; for example, if the cell contains the value 2 when the value should have been 3, just type over the contents of the cell.
If, however, the cell contains a long string of information or a complex formula, you might do better to edit the contents of the cell. To edit the information in any cell, take any of the following actions:
- Double-click the cell containing the information you want to change.
- Select the cell and press F2.
- Select the cell and click in the Input Line at the location where you want to edit.
If you take either of the actions in the first two bullets, you’ll see a vertical insertion point somewhere in the information you want to edit. If you use the last method, the vertical insertion point appears in the Input Line (see Figure 3.12).
To make changes, use the left and right arrow keys on the keyboard to position the vertical insertion point at the location that you need to change. Press the Backspace key to delete the character immediately to the left of the vertical insertion point, or press the Delete key to delete the character immediately to the right of the vertical insertion point. To add characters, simply type; Quattro Pro inserts the characters starting at the location of the vertical insertion point without typing over any characters already in the cell.
Figure 3.12 When you edit a cell by clicking the Input Line, a vertical insertion point appears somewhere within the information stored in the cell, marking your place to begin editing.