Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

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

  • yellow-01.jpg Select the cell that contains the formula you want to edit.
  • yellow-02.jpg Press F2 to change to Edit mode.
  • yellow-03.jpg If necessary, use the Home, End, and arrow keys to position the insertion point within the cell contents.
  • yellow-04.jpg Use any combination of Backspace and Delete to erase unwanted characters, and then type new characters as needed.
  • yellow-05.jpg Click the Enter button on the formula bar, or press Enter.

Copy a Formula Using AutoFill

  • yellow-01.jpg Select the cell that contains the formula you want to copy.
  • yellow-02.jpg Position the pointer (fill handle) on the lower-right corner of the selected cell.
  • yellow-03.jpg Drag the mouse down until the adjacent cells where you want the formula pasted are selected, and then release the mouse button.

Copy and Paste a Formula

  • yellow-01.jpg Select the cell that contains the formula you want to copy.
  • yellow-02.jpg Click the Home tab.
  • yellow-03.jpg Click the Copy button.
  • yellow-04.jpg Select one or more cells where you want to paste the formula.
  • yellow-05.jpg Click the Paste button or click the Paste button arrow, point to an option to display a live preview of the paste, and then click to paste the item.
  • yellow-06.jpg Click the Paste Options button, point to an option for the live preview, and then select the option you want.

If you don’t want to paste this selection anywhere else, press Esc to remove the marquee.

  • + Share This
  • 🔖 Save To Your Account