COPY A WORKSHEET

Prev Show Me Step-By-Step Next

Get Ready
Determine the name of the worksheet you want to copy.
Example: Sheet1
Decide whether you want to copy the worksheet to another workbook or another sheet in the current workbook.

Begin
Right-click the sheet tab bearing the name of the worksheet you want to copy. This is located at the bottom-left side of the window.
Click Move or Copy… on the quick menu. In a few moments, the Move or Copy dialog box will display.
If you want to copy the worksheet to a different workbook, select its name from the To book list.
Click the name of the sheet before which you want to place the copy.
Example: Sheet3
Click the checkbox in front of the words “Create a copy.”
Click the button.