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 pointer 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 Home tab, click Cut. |