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

How To Easily Copy And Move Sheets Between Workbooks


Over time you'll probably find yourself reorganizing your Excel workbooks. That's a good thing!

To make reorganizing a little easier, here are some shortcuts for moving and copying sheets between workbooks.

Shortcut #1:

  1. Right-click on the sheet tab you want to move or copy;
  2. Select Move or Copy;
  3. From the 'To book' dropdown, select the destination workbook; Optionally you can choose where, within the workbook, you want to place the sheet. If you want to move the sheet, retaining a copy in the original workbook, select 'Create a copy' and then click OK;
Maybe you already knew that one. Well, here's another method I bet you'll find even easier. This one's really cool!

Shortcut #2:

  1. Close all workbooks except for the ones you are reorganizing.
  2. From the Windows menu select Arrange;
  3. Select the Horizontal option button, and click OK.
  4. Now you can simply drag and drop sheets between these workbooks.
Remember, when you want to copy a sheet you have to hold down the CTRL key when dropping the sheet into the other workbook. You will notice a small plus sign next to the sheet that tells you that you are copying rather than moving the sheet.

It's always a good idea to have a backup copy of your workbooks before making any drastic changes.


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.