Two or more adjacent sheets
Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet.

Two or more nonadjacent sheets
Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets.

Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.

Grouping allows you to edit or format several worksheet at the same time.Changes made to the active sheet will be reflected in all the worksheet grouped together. To select