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.
Windows keys and context
Sheet grouping acts on worksheet tabs, rather than cells or open workbook windows.
Shift+Click
Group selected worksheets. Microsoft reference ↗
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.
Instruction 1 of 3: Click the Jan sheet tab.
Expected result: Jan, Feb and Mar form a group until you select the unselected Notes tab.
Recall the keys
Which listed Windows combination or sequence starts this operation in the context above?
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.