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

Chapter 3. Building Basic Formulas > Copying a Formula Without Adjusting Relati...

Copying a Formula Without Adjusting Relative References

If you need to copy a formula but don't want the formula's relative references to change, follow these steps:

1.
Select the cell that contains the formula you want to copy.

2.
Click inside the formula bar to activate it.

3.
Use the mouse or keyboard to highlight the entire formula.

4.
Copy the highlighted formula.

5.
Press Esc to deactivate the formula bar.

6.
Select the cell in which you want the copy of the formula to appear.

7.
Paste the formula.

NOTE

Here are two other methods you can use to copy a formula without adjusting its relative cell references:

  • To copy a formula from the cell above, select the lower cell and press Ctrl+' (apostrophe).

  • Activate the formula bar and type an apostrophe (') at the beginning of the formula (that is, to the left of the equals sign) to convert it to text. Press Enter to confirm the edit, copy the cell, and then paste it in the desired location. Now delete the apostrophe from both the source and destination cells to convert the text back to a formula.


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