Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting/Deleting Columns in Tables
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting/Deleting Columns in Tables
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 On Tue, 14 Oct 2008 10:58:00 -0700, KimPotter wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting/Deleting Columns in Tables
I am working with Excel 2007. I have data in a table (A1:D25), 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" wrote: 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 On Tue, 14 Oct 2008 10:58:00 -0700, KimPotter wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CF goes crazy when deleting/inserting rows | Excel Discussion (Misc queries) | |||
Inserting/deleting rows between worksheets | Excel Worksheet Functions | |||
inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
Inserting/Deleting Spaces | Excel Worksheet Functions | |||
Pivot tables - inserting columns | Excel Worksheet Functions |