Excel 2003 & 2007 - Quickest Ways to Copy Worksheets.

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 and 2007.

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 and 2007.

• Make sure both workbooks are open.


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


• Choose Vertical, and then OK.


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


• Left-click and drag the worksheet from one workbook to another.

For additional information:

Intro to Excel 2007 - Atlanta Training class.

Excel 2003 Basics - Atlanta Training Class.


Excel 2003 Intermediate - Atlanta Training Class.