Editing a Formula

You can edit formulas just as you do other cell contents, using the formula bar or working in the cell. You can select, cut, copy, paste, delete, and format cells containing formulas just as you do cells containing labels or values. Using AutoFill, you can quickly copy formulas to adjacent cells. If you need to copy formulas to different parts of a worksheet, use the Paste command or Paste Options button.

Edit a Formula Using the Formula Bar

Image Select the cell that contains the formula you want to edit.

Image Press F2 to change to Edit ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.