Inserting/Deleting Columns in Tables
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
On Tue, 14 Oct 2008 12:50:01 -0700, KimPotter
wrote:
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?
|