What do I mean by that?. Well, when you copy of formula and paste it to a new range of cells, like another location in your worksheet or workbook, well, Excel is really helpful and adjusts the formula.
For example –
is copied to the Column C then the formula is adjusted accordingly to
If you do not want this helpful assumption by Excel then it is easy to make a copy without these adjustments.
- Hit F2 to enter the Edit mode for formulas (you can confirm you are in edit mode by looking at the bottom left of the Excel screen where you will see Edit).
- Next, highlight the formula the hit CTL+C to copy the formula as text.
- Go ahead and paste it into the new cell where you want the formula.
- That’s it you now should have correctly made an exact copy of your Excel formula.
- You can the exit out of Edit mode in Excel by hitting the Escape key (ESC) on your keyboard.
If you want to learn more about how awesome Excel is you to take a look our Recommended Excel Online Courses, if you want to take your Excel learning to the next level then check out Chandoo’s VBA Classes.
If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips. If you want to see all of the blog posts in the Macro Mondays Series you can do so by clicking on the link below.