• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Building a Worksheet with Excel > Editing and Copying a Formula

Editing and Copying a Formula

You can edit formulas just as you do other cell contents: use the formula bar or work in the cell. When you select a cell to edit a formula, the status bar displays Edit Mode, indicating that you can edit the contents of a cell. You can select, cut, copy, paste, delete, and format cells that contain formulas, just as you do cells that contain 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 Office Clipboard.

Edit a Formula Using the Formula Bar

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

Press the F2 key to change to Edit Mode.

If necessary, use the Home, End, and arrow keys to position the cursor within the cell contents.

Use any combination of Backspace and Delete to erase unwanted characters, and then type new characters as needed.

Click the Enter button on the formula bar, or press Enter.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint