Use groups to affect multiple worksheets : Worksheet « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Workbook Worksheet
  3. Worksheet
Click a sheet tab. 
           Press and hold Shift and click another sheet tab to group worksheets
Click a sheet tab. Press and hold Shift and click another sheet tab to group worksheets
Right-click a grouped sheet tab. 
           Then click Ungroup Sheet on the shortcut menu.
Right-click a grouped sheet tab. Then click Ungroup Sheet on the shortcut menu.








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