Select worksheets : Worksheet « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






If necessary, click a sheet tab scroll button to display other tabs.
If necessary, click a sheet tab scroll button to display other tabs.
Click a sheet tab to make it the active worksheet.
Click a sheet tab to make it the active worksheet.
To select multiple worksheets, press and hold Ctrl as you click other sheet tabs
To select multiple worksheets, press and hold Ctrl as you click other sheet tabs
When multiple worksheets are selected, [Group] appears in the title bar.
When multiple worksheets are selected, [Group] appears in the title bar.








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