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.

Oken .

Copper Contributor

Jul 06, 2020

Did you try to press F4 when you highlight the references. F4 should toggle between absolute and relative references. MRennie

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

Forum Discussion

Excel Absolute Reference Copy

Resources