Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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)

share|improve this question
add comment

6 Answers 6

up vote 4 down vote accepted

If you're not set on using the keyboard only, highlight the column, either by Ctrl+Space or clicking on the column header. Then press and hold down the Shift key. In some environments you may see the selection box (border) around the column change to an I-bar. Then you can drag the column to the left or right (using the mouse) and it will move the column there without overwriting data or leaving a blank column.

This also works with rows, and with ranges of columns or rows. The I-bar changes to horizontal or vertical as you move the range, and separates the columns or rows where it will move the range to.

So to summarize,

Ctrl+Space to select the source column.

Hold down Shift while you drag the column.

share|improve this answer
    
And if you use (Ctrl)+(Shift) while you drag, it will create new column(s) or row(s) and copy the data there, much like (Ctrl)+drag in Microsoft Word. –  Scott Aug 1 '13 at 22:36
1  
Nice! I've accepted your answer even though it requires brief usage of the mouse. As it might not be obvious to everyone: dragging the column is done by first hovering over the column borders (cursor changes into 4-arrows symbol) before pressing the left mouse button. –  Rabarberski Aug 5 '13 at 7:03
add comment

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.

share|improve this answer
    
Yep, that works (even in Excel 2007), bit long-winded though :-) –  Rabarberski Aug 20 '10 at 9:00
    
Indeed, if you wish to use it a lot then record it as a macro and assign it a keyboard shortcut. Or try using AutoHotkey to automate it without having to add macros to your files. –  DMA57361 Aug 20 '10 at 9:21
3  
Instead of Alt+I then E, you can simply hit Ctrl + +. This will insert just the same. –  variant Aug 20 '10 at 11:51
    
If you are in Excel 2007 / 2010 and are trying to move a column in a table be sure to select from the header cell with Ctrl + Space in the desired column and not just any cell in the column. Otherwise you'll get the error This operation is not allowed. The operation is attempting to shift cells in a table on your worksheet. –  Urda Dec 6 '11 at 17:13
add comment

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

share|improve this answer
add comment

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.

share|improve this answer
add comment

Try the following:

  • Double-click on the column you would like to move (it will highlight the whole column)
  • Hit Ctrl+X at the same time (you will see the selection cut)
  • Hit the arrow key to move in whichever direction you want to move (LEFT arrow Or Right Arrow)
  • Point between the columns, and release the mouse
  • Where you point after the next right column will be deleted automatically (careful: select one Blank column, then move the column )

Example: If you moving a column Between A & B, it is possible that B will be remove) so before moving any column, bring up an empty column between two columns and after you start moving the column.

In summary, select the column (Double click), CTRL+X, move with arrow left or right.

share|improve this answer
    
This was a bit difficult to follow, I tried my best with it, but you may want to clarify it some more. –  jonsca Dec 8 '12 at 8:51
add comment

The method by Hemal (?) works, but the trick is to create a new column where you want to move to, Excel will leave a blank column behind where the data were previously to be used or deleted.

  1. Double click when the down-pointing arrow appears above the column header for the data you want to move.
  2. Hit Ctrl+x
  3. Move with arrow keys to the location of the new column and hit Enter
  4. Hit Enter

Data moved to the new column.

If you hit enter on a populated column, it is overwritten. Not slick or "clean", but it's an easy shoehorn to use.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.