Forum Discussion
MRennie
Jul 06, 2020Copper Contributor
Excel Absolute Reference Copy
Older versions of Excel used to have a feature that you could toggle to allow you to copy and paste using Absolute References. I can't seem to find this feature in the current version of Excel. It se...
- Jul 06, 2020
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
Jul 06, 2020Copper Contributor
Thanks Oken .
Unfortunately that simple adds or removes the '$' from the formulas. What I want is to be able to copy a bunch of cell contents and paste them somewhere else without it changing the formulas, regardless of whether I've set the '$' or not. This is how it used to work.
Thanks,
SergeiBaklan
Jul 06, 2020Diamond Contributor
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.
- MRennieJul 06, 2020Copper Contributor