How do I reorder Excel Table columns?

Question

I have an Excel table (the one where you can reference by column names) and I need to reorder some columns:

Region A	Region B	Total	Region C
150	100	350	100

[Total] is [Region A]+[Region B]+[Region C]

I need to move [Region C] column to the left of [Total] but I can't simply select the whole spreadsheet column and cut & paste (there are other data below the table)

If I inserted a new table column to the left of [Total] and manually cut/paste Region C, the [Total] would be wrong (it would then become [Region A]+[Region B]+[Column 1] where column 1 is empty.

So what's the correct way to move Table columns in this case?

Answer 1

You may select the column and take cursor to its border, cursor will convert to a big PLUS sign. Now you just drag and move to other location.

Answer 2

Hi,

Try this

1. Select C1:C(till last cell of data) and press Ctrl+X
2. Go to cell E1 and press Ctrl+Shift+=

Hope this helps.