Excel Table : moving a column messes up with the width of other columns

Joined
Sep 15, 2022
Messages
2
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
- OS : MacOS and Windows (tested on both)
- Excel version : 16.64

- Issue
When I do SHIFT + drag & drop a column within an Excel Table (it's NOT a Pivot Table, it's a normal Table), it will mess up with the column widths. It doesn't behave like this when it's not a Table.

- Screenshots of the issue
A) Initial state
B) Press SHIFT and drag and drop column to move it somewhere else
C) Final state : The width of many columns has changed

Is that a bug or a feature?
 

Attachments

  • A.png
    A.png
    110.1 KB · Views: 42
  • B.jpg
    B.jpg
    234.8 KB · Views: 41
  • C.jpg
    C.jpg
    216.1 KB · Views: 37

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
I don't know if Microsoft classifies it as a bug (there could be "logic" to it), but it (columns don't maintain their width in Excel Tables when you try to move one) definitely has been happening to me since I started playing with Excel tables in Office 2016.

I actually wrote a "column swap, column mover, and column shuffler" (the column "shuffler" will reorder columns that you select in the order that you select them, and move them to the right of a destination column that you select) for Excel Tables so that it would preserve the column widths and make moving columns easy.

(So you're not alone.)
 
Upvote 0
Ok, good to know I'm not alone here.

I posted the issue on reddit and a guy sent an interesting animation showing that you can also move just the Table columns (instead of the sheet columns). It still changes the width of columns but in a more "logical" way.
I also posted the question on the microsoft forum : Redirecting
 
Upvote 0
I found a simple work around.
Highlight any column in your existing table, right click on it and click copy.
Click on the header of the column to the right of the column where you want to insert a new column, right click and choose to insert those cells just copied.
If you were inserting a column say, to the beginning of your existing table, that column is now currently sitting outside your table.
Click 'Table Design' on the menu bar and choose 'Resize table'. Then reassign the correct top left cell, eg instead of B1-G360, change it to A1-G360.

Hope that helps.
 
Upvote 0

Forum statistics

Threads
1,226,729
Messages
6,192,696
Members
453,747
Latest member
tylerhyatt04

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top