Excel – How to move columns with drag and drop in Excel 2011

microsoft excelmicrosoft-excel-2011

How can I move columns with drag and drop in Excel 2011?

Best Answer

Answered by deargeek.net:

  1. Select the Column or Row you want to move
  2. Move your mouse pointer up to the blue edge of the selection until it changes from a cross to a regular pointer arrow or hand. Note: The mouse pointer must be on one of the highlighted cells and not on the row or column headings.
  3. Hold down the shift key and click and drag the column/row to the new position. A faint “I” bar that runs the entire length of the row or column, along with a box indicating where the new row or column appears.
  4. Release the mouse button and then leave the SHIFT button, and your row or column is moved.

I have verified this with Excel 2011 (14.0.2) running in Mac OS 10.6.7.

Related Question