Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.