Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/02/Copy-formulas-without-changing-reference.xlsx

In this video I demonstrate how to copy formulas without changing cell references within formula. I demonstrate three methods:

1)copy formula text
2)find and replace equals sign in formula and
3)copy to and paste from Notepad

This video answers the following queries:
How do I keep the cell reference when copying formulas in Excel?
How do you copy a formula in Excel and keep cell references?
How do you move cells in Excel without affecting formulas?
How to move cells in Excel without affecting formulas?
Excel drag cells without changing formula
------------------------