Inserting/Deleting Columns in Tables

[KimPotter]

I am playing around with inserting/deleting columns in a table, but I also
have data in columns to the right of my table.

When I use the "Insert, Table column to the left" command, the rows of data
immediately across from the table are shifted to the right. Rows of data that
extend below the table area are left in place. This creates unbalanced
columns of data.

However, if I simply click on a column, right click and insert a column, it
achieves a better result, which is EVERYTHING to the right of my table is
shifted to the right, not just the rows across from the table.\

I "thought" that you were able to add/delete rows & columns in a table
without disturbing other data. I am able to delete/insert rows in my table
without disturbing the adjacent data, why isn't this true for columns?

 

[Gord Dibben]

When you insert rows or columns in a 2003 List or 2007 Table, the adjacent
rows or columns have to go somewhere.

Your statement "I am able to delete/insert rows in my table
without disturbing the adjacent data" is only partially true.

When you insert a row in your table, the rows below the table shift down
although the rows adjacent to the table do not shift down.


Gord Dibben MS Excel MVP

 

[KimPotter]

I am working with Excel 2007. I have data in a table (A125), and data not
in a table (G1:J35). I do not have data below the table because I want to be
able to expand downward.

As I explained, I am concerned mostly about how Excel operates when I
insert/delete a column in my table, using the "insert, table column to the
left" command.

When inserting a column using this method (inserting to the left of column
D), the data in the range G1:J25 shifts to the right, to the new range
H1:K25. This leaves some of my original data in G26:J35 misaligned.

Why doesn't Excel just shift EVERYTHING to the right when inserting a column
in a table, like it does when inserting a column not in a table?

 

[Gord Dibben]

Excel does not know you want to shift data below the bottom right corner
bounds of the table to the right.

Only shifts adjacent to table range when inserting a column in table as you
have found.

Why is up to the developers. Probably meant to preserve integrity of that
data placement but no ideas otherwise.

You know the workaround so use that.


Gord