Select one or multiple worksheets

By clicking the tabs of worksheets (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.) (or sheets) at the bottom of the window, you can quickly select a different sheet. If you want to enter or edit data on several worksheets at the same time, you can group worksheets by selecting multiple sheets. You can also format or print a selection of sheets at the same time.

To select Do this
A single sheet

Click the sheet tab.

Active sheet tab

If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

Tab scrolling buttons

Two or more adjacent sheets Click the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select.
Two or more nonadjacent sheets Click the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.
All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.).

Tip    When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

 Notes 

  • Data that you enter or edit in the active sheet (active sheet: The sheet that you're working on in a workbook. The name on the tab of the active sheet is bold.) is reflected in all selected sheets. These changes might replace data on the active sheet and, perhaps unintentionally, on other selected sheets.
  • Data that you copy or cut in grouped sheets cannot be pasted on another sheet, because the size of the copy area includes all layers of the selected sheets and is therefore different from the paste area in a single sheet. Make sure that only one sheet is selected before you copy or move data to another worksheet.
  • When you save a workbook that contains grouped sheets and then close the workbook, the sheets that you selected remain grouped when you reopen that workbook.
 
 
Applies to:
Excel 2007