• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cut and Paste a column of a Table

AT--o

New Member
Hi,


After cutting and pasting a column from a Table, the formulas that were referring to the mentioned column, stick to the now empty column.

For example I have a column named A, I cut it and paste it but the cells referring to A now refer to Column1 which is the default name excel assigns to the now empty column.


Thank you all.
 

Hui

Excel Ninja
Staff member
As a Table you have told Excel that there is specific relationship inherent between the members of the table.

The fact that you have removed some members doesn't change the internal relationships
 
Top