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
When you use the fill handle to fill to the right, Excel will dynamically adjust the column reference, from Price ex to VAT% to VAT€ to Price incl.
To avoid this, use
=SOM(Tabel1[[Price ex]:[Price ex]])
That will "fix" the column reference when you fill to the right.