Excel Tip – Quickest Ways to Copy Worksheets.

Untitled Document
Copying worksheets is one of my favorite Excel time savers. If you have an Excel file (workbook)  that has similar worksheets, such as a budget workbook with a sheet for every month, copying worksheets will save you time.
This tip works with Excel 2003 2010.Some of you may know the traditional way to copy a worksheet (Excel 2003 instructions):
  • Click the Edit menu.


  • Choose Move or Copy Sheet.



  • Make certain the Create a Copy box is checked.



  • Select where you want to place the sheet (in a new workbook file, or in the current workbook).



  • Click OK.


Did you know that there’s an even quicker way to do this? This works in Excel 2003 and 2007.
To copy a worksheet in the same workbook.
  • Hold down the Ctrl key.


  • Left-click and drag the worksheet.


To copy a worksheet to another workbook. Excel 2003 – 2010.
  • Make sure both workbooks are open.


  • Click the Window menu, then Arrange. In Excel 2007/2010, Click the View Tab, and then Arrange All.



  • Choose Vertical, and then OK.



  • At this point, both workbooks should be open side-by-side.



  • Hold down the CTRL key. Left-click and drag the worksheet from one workbook to another.


Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users

About the Author

Jackie Kiadii has 20 years of Excel experience, and teaches the following courses in Excel 2007 and 2010: Certification Prep, Basic through Advanced, Pivot Tables, and Macros/VBA.

Need onsite group training? Call 404.297.6700. Our courses are affordable and customized to your needs. Available for groups of 4 or more students.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>