Forum Discussion
Excel Absolute Reference Copy
The workaround to copy/paste formulas is like https://www.xelplus.com/copy-excel-formulas-without-changing-cell-references/, it was the same on previous versions of Excel if only you didn't use some third-party add-ins.
MRennie I don't recall that being the case in the past but I don't remember what I ate yesterday. That said, here are a couple things that might help?
A) if you want the exact same formula pointing at the exact same cells then why not just 'paste link' which basically pastes =[previous cell ref] which will give you the same value at that new location as the previous location without excel needing to repeat the calculation.
B) there is a difference between copying a cell and cut and paste a cell. SO, if you copy it will do that relative position but if you cut and paste it won't. That said you, you can only cut & paste 1x at a time (i.e. you can not cut, paste, paste, paste, ....). But what you can do is (for example copying range A1:M100 to multiple locations)
- copy cells A1:M100 down to A101
- cut A1:M100
- paste in new location
- copy A101:M200 back to A1
- repeat steps 2-4 as needed
I know it isn't pretty but might help with what you need.
[edit] didn't see the new reply until after I posted. The solution in that link is probably easier than this one.