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.
- I know this Hans.
But my question was:
why is the reference adjusted when I use the fill handle and NOT ADJUSTED when I use Ctrl+c and Ctrl+v?????
Normally there is no difference between those 2 ways of copying (as far as I know)The only explanation I've seen from Microsoft is
Using structured references with Excel tables - Microsoft Support
- Thanks! At the end of this explanation in the Note I find the answer: yes there is a difference in the way you copy!
As far as I know, this is the only situation with a difference between copying with Ctr-C?Ctrl-V and Fill right...
Saskia
