Forum Discussion
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, ...
This is always the case. In fact I used to use this as a trick to 'move' my relative references by copy to another area, cut and paste the offset I wanted and then copy it back. But now with dynamic arrays I don't seem to need that as there is only 1 formula for everything.