Jul 06 2020 09:35 AM
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 seems that the only option now is to use the dollar sign on cell references in formulas.
Does anyone know what I'm referring to and if the old feature still exists?
Thanks,
Mike
Jul 06 2020 10:04 AM
Did you try to press F4 when you highlight the references. F4 should toggle between absolute and relative references. @MRennie
Jul 06 2020 12:10 PM
Jul 06 2020 12:27 PM
SolutionThe 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.
Jul 06 2020 12:34 PM
Jul 06 2020 12:37 PM - edited Jul 06 2020 12:41 PM
@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)
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.
Jul 06 2020 12:27 PM
SolutionThe 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.