Forum Discussion

Copper Contributor

Jul 14, 2023

Excel 365 cut and paste won't allow for relative referencing

Hi, In excel 365, when I copy an paste cells without fixed/absolute references (no $$ on any cells), they are pasted using relative referencing. However, when I *CUT* and paste these cells, ...

excel

Formulas and Functions

office 365

tanayprasad

Brass Contributor

Jul 14, 2023

Hi,

You can select "Paste Formulas" in the paste options when you want to cut and paste your data. This will allow relative referencing.

Also, if you frequently need to cut and paste cells with relative referencing, you can customize the Paste Options to make "Paste Formulas" the default option.

Best Regards.

SergeiBaklan
Diamond Contributor
Jul 14, 2023
tanayprasad

IMHO, Paste Special doesn't work with Cut, only with Copy.
- tanayprasad
  Brass Contributor
  Jul 17, 2023
  Yes. You're actually correct.
  It works with Copy.