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






Click the sheet tab to the right of where you want to insert the new sheet.
Click the sheet tab to the right of where you want to insert the new sheet.
Click the Insert Worksheet icon at the end of the sheet tabs.
Click the Insert Worksheet icon at the end of the sheet tabs.
Or click the Home tab. Click the Insert Cells button. Then click Insert Sheet.
Or click the Home tab. Click the Insert Cells button. Then click Insert Sheet.
A new worksheet is inserted to the left of the selected worksheet.
A new worksheet is inserted to the left of the selected worksheet.








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