• 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


  • 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


New Member

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.


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