Edit a Part of a Formula

1. Double-click the cell. Or select the cell and press F2.

2. 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.