Grouping Worksheets

Hold down the "Control" key while clicking specific worksheet tabs to group them. Spreadsheets that are linked together update at the same time. For example, if you group sheets 1 and 2 and type the word "test" in cell B2 on sheet 1, you can click over to sheet 2 and see the word "test" in the same cell. If you want to group multiple tabs in a row, select the tab for the first sheet you want to include in the group, hold the "Shift" key and click the last tab to group everything between the active tab and the one you click.

Ungrouping Excel Worksheets

When you're done with your edits, click a tab that isn't part of the group to disband the group. If every tab is linked, hold down the "Control" key and click any tab to deselect it from the group so it can be selected to ungroup the rest. Alternatively, right-click any grouped tab and select "Ungroup Sheets."