Selection · original practice scenario
Select nonadjacent worksheet tabs
The workbook has Jan, Feb and Mar sheets; only Jan and Mar need a shared header change.
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.
Ctrl+Click
Group selected worksheets. Microsoft reference ↗
Walk through the operation
- Click the Jan sheet tab.
- Hold Ctrl and click the Mar sheet tab.
- After inspecting the group, click the unselected Feb tab to ungroup.
Instruction 1 of 3: Click the Jan sheet tab.
Expected result: Jan and Mar form a group until you select the unselected Feb 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 adjacent 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.