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

How To Easily Move A Range Of Cells From One Sheet To Another

  1. Select the range of cells you want to move
  2. Hold down the ALT key while dragging the selected cells down to the destination sheet tab. That sheet will pop open.
  3. Release the ALT key.
  4. Move the selected cells to the range where you want to paste them and release the mouse button.
Note that if you want to copy the cells instead of move them, just hold down the CTRL key while releasing the mouse button in step 4.

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.