Copy Sheets to Another Workbook in Microsoft Excel

Often, rather than trying to copy cells to another workbook or to another worksheet, it's much easier to just copy the whole worksheet, and then delete anything you might not have wanted copied over.

Just right-click the sheet tab to get the menu. Choose Move or Copy.

The Move or Copy dialog appears. From the top drop-down, you can choose from any open workbook, or leave it as the workbook you're already in. Check the Create a copy box. (I always check this even if I want to move the sheet because I want to make sure it's safely moved before I delete it.) Hit OK.

If you want to copy multiple sheets, there's several ways to select them. You can hold your shift key and select the first and last worksheet tabs, and all tabs in between are automatically selected. You can hold the Ctrl key down and only the tabs you click on are selected. Or you can right-click and choose Select All Sheets. Then, you can continue following the instructions as above. Just right-click any one of the selected sheets to get the menu.

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved