Selection · original practice scenario
Select adjacent worksheet tabs
Jan, Feb, Mar and Notes appear in that tab order; Jan through Mar need the same print setup.
Start here: Windows worksheet tab bar; selecting a group of sheets
Edits in a grouped sheet can affect every selected sheet. Ungroup before returning to ordinary editing.
Follow these instructions in your own desktop Excel workbook. This page explains the operation; it does not send commands to Excel.
Mac keys and context
Sheet grouping acts on worksheet tabs, rather than cells or open workbook windows.
This catalog has no verified Mac binding for this operation. The steps below describe Windows. Choose Windows to use the walkthrough and recall controls.
Walk through the operation
- Click the Jan sheet tab.
- Hold Shift and click the Mar sheet tab.
- After inspecting the group, click the unselected Notes tab to ungroup.
Expected result: Jan, Feb and Mar form a group until you select the unselected Notes tab.
Related walkthroughs
- Extend a rectangular selection to a clicked cell
- Add a separate cell or range to a selection
- Select nonadjacent worksheet tabs
- Select differences within one column
Catalog updated 2026-10-18. US keyboard notation: + joins held keys; commas separate successive presses. Function keys may require Fn. Desktop instructions are separate from this browser's own keyboard shortcuts.