Select one or more worksheets in Excel 2007

By clicking the sheet at the bottom of the Excel window tab, you can quickly select a different worksheet. If you want to enter or edit data on several worksheets at once, you can combine worksheets by selecting multiple worksheets. You can also format or print several selected worksheets at the same time.

	operation
a worksheet	Click the sheet's label. If you don't see the desired label Check, click the Label Scrolling button to display the label you want, and then click the label.
two or more adjacent worksheets	> Click First tab of the worksheet, and then hold down SHIFT while you click the label of the last worksheet you want to select.
two or more nonadjacent worksheets	> Click First Sheet, and then hold down CTRL while you click the tabs of the other worksheets you want to select.
all worksheets in the workbook	> Right-click a job As a table, and then click the shortcut menu shortcut menu: A menu that displays a list of commands related to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10. , Select all sheets .

Tip When you select more than one worksheet, the word [workgroup] appears in the title bar at the top of the worksheet. To deselect more than one worksheet in a workbook, click any unselected worksheet. If you don't see a worksheet that is not selected, right-click the tab for the selected worksheet, and then click UngroupSheet on the shortcut menu.

Comments　　

• On the active worksheet active worksheet: A worksheet that users are working on in a workbook. The name on the active sheet label is bold. ), the data you enter or edit is reflected in all selected worksheets. These changes may replace the data on the active worksheet and may inadvertently replace the data on other selected worksheets.

• Data that is copied or cut from a grouped worksheet cannot be pasted into another worksheet because the size of the copied area includes all the layers of the selected worksheet, so it is different from the pasted area on a separate worksheet. Before you copy or move data to another worksheet, make sure that you have selected only one sheet.