Adding a column to an Excel table

[Suzi-Q]

Excel 2007 - it was my understanding that if you add a column to a table, it
doesn't affect other data that is not in the table. However, when I add a
column to my table, it shifts half the data in the other block over. A row
works fine but a column doesn't. Is my textbook incorrecta?

 

[Shane Devenshire]

Well that depends on how you add the column to the table.

1. If you are outside the table, in the column directly adjacent to the
table and you type a title or data this column is include in the table and
does not affect anything else.
2. If you are outside the table, in the column direcly adjacent to the table
and you right-click the column letter and choose Insert everything is shifted
to the right
3. If you are inside the table and you right-click a cell and choose Insert,
Table Column to the right Excel will push the data adjacent to the table to
the right but not the data that is below the table.

 

[Suzi-Q]

Then I think the textbook is wrong. It has us click inside the table and
insert a column to the left. All the stuff in the non-table block shifted to
the right. The text says that it doesn't. Boo on them. I may write to the
publisher. Thanks.