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
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)
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