Forum Discussion

Copper Contributor

Jul 06, 2020

Solved

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...

excel

SergeiBaklan
Jul 06, 2020
MRennie

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

Copper Contributor

Jul 06, 2020

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,

MRennie

SergeiBaklan

Diamond Contributor

Jul 06, 2020

MRennie

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
Copper Contributor
Jul 06, 2020
Thanks SergeiBaklan

This will work. I guess they no longer have the built in feature.