Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a column to an Excel table
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a column to an Excel table
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Suzi-Q" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a column to an Excel table
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. "Shane Devenshire" wrote: 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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Suzi-Q" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Chart - Adding text in the column in Excel 2007 | Charts and Charting in Excel | |||
Excel 2000: Adding column D based on value in column A | Excel Worksheet Functions | |||
adding rows to excel table | New Users to Excel | |||
adding images to excel table automatically | Excel Discussion (Misc queries) | |||
adding characters in excel column | Excel Discussion (Misc queries) |