Forum Discussion
Solved
Different results when copying with Ctrl-C/Ctrl-V and with fill handle
I often use Excel tables and therefore also table formulas. And I found something strange… When copying a table formula referring to a column in a table, the result is depending on the way it is cop...
The only explanation I've seen from Microsoft is
Using structured references with Excel tables - Microsoft Support
Pasting and filling with Ctrl+r locks the reference.
Dragging the cell with the fill handle will drag the reference as well.
If you want to lock the reference so you can drag with the fill-handle, change the original formula to this:
=SOM(Tabel2[[Price ex]:[Price ex]])
You can watch this video for more detail.