Copy a Worksheet : Worksheet « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Workbook Worksheet
  3. 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.
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.
The sheets of the selected workbook appear in the Before Sheet list.
The sheets of the selected workbook appear in the Before Sheet list.

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.
Select the Create a copy check box. Click OK.
Select the Create a copy check box. Click OK.




7.1.Worksheet
7.1.1.Select the entire worksheetSelect the entire worksheet
7.1.2.Select worksheetsSelect worksheets
7.1.3.Name or Rename a WorksheetName or Rename a Worksheet
7.1.4.Select all worksheetsSelect all worksheets
7.1.5.Insert a WorksheetInsert a Worksheet
7.1.6.Delete a WorksheetDelete a Worksheet
7.1.7.Move a Worksheet Within a WorkbookMove a Worksheet Within a Workbook
7.1.8.Use groups to affect multiple worksheetsUse groups to affect multiple worksheets
7.1.9.Copy a WorksheetCopy a Worksheet
7.1.10.Hide a WorksheetHide a Worksheet
7.1.11.Unhide a WorksheetUnhide a Worksheet
7.1.12.Change Worksheet Display OptionsChange Worksheet Display Options
7.1.13.Copy Excel Data between WorksheetCopy Excel Data between Worksheet