Excel: keyboard shortcut to move (swap) column left or right?

Question

Is there a way to move a column (or row) to the left using only the keyboard? I known I can use ctrl-space (shift-space) to select a column (row), but how to move it to the left or right, actually swapping position with the column to its left or right?

(I am using Excel 2007)

Answer 1

Best I can come up with is something like this (note, this works in Excel 2003 - might not work in 07/10, but you've haven't indicated which version you are using):

Ctrl + Space to select the source col.

Ctrl + X to cut the col.

Left Arrow or Right Arrow to move to the column you want to move the selected column to the left of.

Crtl + Space to select the target col.

Crtl + + to insert the cut cells (with thanks to variant for that useful comment!).

I'm thinking that AutoHotkey or a short macro might be a good way to achieve this.
It should be easy to record a quick Excel macro using the above set of commands, just make sure "Relative Reference" is on.

Answer 2

According to the Excel keyboard shortcuts list, there is no built-in shortcut to achieve what you want.

Answer 3

Instead to move a single cell or row or column do the following:

CTRL+X

select the location where you have to move and press right click or the button between Windows key and CTRL key select insert cut cells the cells will be replaced.