"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

How To Move Rows And Columns Quickly And Easily

This is one of those really great tricks I discovered only after years of doing it the hard way. Not only will this shortcut allow you to eliminate the tedious and frustrating process you are using now, but it will also save you a lot of time.
For many Excel users, moving rows or columns involves the tedious process of inserting, cutting, pasting, and deleting.

I want to share with you a quick and easy process for moving rows and columns that works like magic.

  1. First, select the entire rows or entire columns you want to move (must be a contiguous selection).
  2. Move your mouse pointer to the edge of the selection until it changes from the white cross to an arrow pointer.
  3. Hold down the SHIFT key, then hold down your left mouse button and drag the rows or columns to the new position. You'll see an insertion bar between the two rows or columns you are pointing to.
  4. Release the mouse button before you release the SHIFT key and the rows or columns are moved from their original location without overwriting any data. All formulas and relative references are adjusted accordingly.
WARNING: If you let up on the SHIFT key before you release the mouse button, Excel will try to copy the selection instead of move it and will ask you if you want to "replace the contents of the destination cells. If that happens hit Cancel or the Esc key and try again making sure you release the mouse button before you let up on the SHIFT key.

This tip also works for cells but it may take a little practice to get the insertion bar to go where you want. Sometimes it's a little tricky. But I'm sure you can do it, just give it a shot. If you make a mistake you can always use Edit, Undo (CTRL+Z).

Rearranging columns or rows in Excel can be tricky, and and can really mess up your spreadsheet if you don't do it right. But using this method to move rows and columns makes it a breeze.

Go ahead and try it now. This one really is a big time saver.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.