- Excel Book Excerpt
Excel Move Rows or Columns with Shift Drag
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 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.
3. Below, 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.
Figure 1180 Shift-drag the border.
4. Release the mouse. Excel will insert the row and shift the other rows down.
For more resources for Microsoft Excel: