February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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
Select the cell that contains the formula you want to edit.
Press F2 to change to Edit ...