Edit a part of a formula

Microsoft Office ShapeSheet

Edit a part of a formula

  1. Double-click the cell. Or select the cell and press F2.
  1. 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.