LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CF goes crazy when deleting/inserting rows DoubleZ Excel Discussion (Misc queries) 1 October 2nd 08 09:33 PM
Inserting/deleting rows between worksheets Klee Excel Worksheet Functions 4 July 22nd 07 07:41 PM
inserting deleting rows?how do i get the other sheets to do the sa cunningham82 Excel Discussion (Misc queries) 0 December 27th 06 09:51 PM
Inserting/Deleting Spaces carl Excel Worksheet Functions 4 April 22nd 05 06:25 PM
Pivot tables - inserting columns Scott Excel Worksheet Functions 1 March 19th 05 01:07 AM


All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"