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.
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
Delete the character to the right
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
Select to the beginning
Replace selected text
Type the new text.
Delete selected text
Press DELETE. Or on the Home tab, click Cut.