Excel: Move Rows or Columns with Shift Drag

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I need to rearrange some rows or columns. Do you have anything faster than the other methods you've described?

Strategy: You might find this method faster than the others:

  1. Select an entire row by pressing Shift+Spacebar or select an entire column by pressing Ctrl+Spacebar.
  2. Grab the thick border around the row or column. Hold down the Shift key and drag the row/column to a new location. When you use Shift+drag, Excel will basically cut the cells and then insert them where you release the mouse. Gotcha: The Shift+drag is critical. If you simply drag, you will do a cut and paste. If you Ctrl+drag, you will do a copy and paste. Both of these will overwrite the destination cells. Only Shift+drag will insert the cells.

  1. Shift-drag the border.
    1. You've selected the entire row. Grab the top border while holding down Shift. As you drag, an insertion cursor shows where the row would be moved to.
    2. Release the mouse. Excel will insert the row and shift the other rows down.