How to Paste Formulas Without Changing Cell Reference in Excel



To copy and paste formulas without changing the cell referenced in the formula select the cell that has the formula in it.
select the formula

Then press f2 to select the cell.
press f2 to select the cell

Highlight the whole formula.
highlight the forumla

Click the copy button.
click on the copy button

Press enter. Then click in the cell you want to move the formula to. Click the paste button. The formula will now be pasted into that cell.
select other cell and click on the paste button

Related posts:

  1. How to Calculate Formulas Across Worksheets in Excel
  2. How to Create and Manipulate Shapes in Excel
  3. How to Export File Into Excel from Microsoft Access
  4. How to Use Scenarios in Formulas in Excel
Posted on February 28, 2013 by . This entry was posted in Office and tagged . Bookmark the permalink.