7.1.9.Copy a Worksheet |
|
Click the sheet tab of the worksheet.
Click the Home tab.
Click the Format button arrow.
Then click Move or Copy Sheet.
|
|
![Click the Home tab. Click the Format button arrow. Then click Move or Copy Sheet.](../../Microsoft-Office-Excel-2007Images/Copy_Worksheet___Click_Home_Tab_Click_Format_Button_.PNG) |
If you want to copy the sheet to another workbook,
click the To book list arrow.
Then select the name of that workbook.
|
|
![If you want to copy the sheet to another workbook, click the To book list arrow. Then select the name of that workbook.](../../Microsoft-Office-Excel-2007Images/Copy_Worksheet___If_You_Want_To_Copy_Sheet_To_Anothe.PNG) |
The sheets of the selected workbook appear in the Before Sheet list.
|
|
![The sheets of the selected workbook appear in the Before Sheet list.](../../Microsoft-Office-Excel-2007Images/Copy_Worksheet___The_Sheets_Of_Selected_Workbook_App.PNG) |
If the workbook does not show up in the To Book drop-down list, you must first open the workbook. |
Click a sheet name in the Before Sheet list.
Excel inserts the copy to the left of this sheet.
|
|
![Excel inserts the copy to the left of this sheet.](../../Microsoft-Office-Excel-2007Images/Copy_Worksheet___Excel_Inserts_Copy_To_Left_Of_This_.PNG) |
Select the Create a copy check box. Click OK.
|
|
![Select the Create a copy check box. Click OK.](../../Microsoft-Office-Excel-2007Images/Copy_Worksheet___Select_Create_Copy_Check_Box_Click_.PNG) |