Edit a part of a formula
- Double-click the cell. Or select the cell and press F2.
- In the cell or the formula bar, edit the formula using the techniques in the following table.
To |
Do this |
Place the insertion point |
Click where you want the insertion point to appear. |
Move the insertion point |
Press the left or right arrow key. |
Delete the character to the left |
Press BACKSPACE. |
Delete the character to the right |
Press DELETE. |
Select text |
Drag the mouse over the text. |
Extend the selection to the left |
Press SHIFT+left arrow. |
Extend the selection to the right |
Press SHIFT+right arrow. |
Select a word |
Press CTRL+SHIFT+right arrow or double-click. |
Select to the end |
Press SHIFT+END. |
Select to the beginning |
Press SHIFT+HOME. |
Replace selected text |
Type the new text. |
Delete selected text |
Press DELETE. Or on the Edit menu, click Cut. |