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.
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
You must log in to post.
Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.
Subscribe
