"How To Excel" Mini-Tutorials|
"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.
Maybe you already knew that one. Well, here's another method I
bet you'll find even easier. This one's really cool!
- Right-click on the sheet tab you want to move or copy;
- Select Move or Copy;
- 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;
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.
- Close all workbooks except for the ones you are reorganizing.
- From the Windows menu select Arrange;
- Select the Horizontal option button, and click OK.
- Now you can simply drag and drop sheets between these workbooks.
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)