How Do You Group Worksheets in Excel?
Hold Ctrl (or Command on Mac) and click each sheet tab you want to include. For a block of sheets that sit side by side, click the first tab, hold Shift, and click the last. Right-click any tab → Select All Sheets grabs the whole workbook.
Once the tabs are highlighted, whatever you type or format in one sheet happens on every sheet in the group — which is exactly what you want when the same title, column widths, or formatting belong on many sheets at once.
The 3 Ways to Group Worksheets
📑 Consecutive sheets → Shift
For tabs in a row, like Jan–Dec or Q1–Q4
🎯 Any sheets → Ctrl
For tabs that are not neighbors
☰ Everything → Right-Click
Group the entire workbook at once
Follow Along: Group Two Sheets Right Now
Click the first sheet tab you want in the group
This is the sheet you'll actually see on screen. If the tabs you want are next to each other, this is your "start" tab.
Hold Ctrl (⌘ on Mac) and click the other tabs
Each tab you Ctrl+Click joins the group. To pull in a whole run of sheets at once, hold Shift and click the last tab instead — everything in between gets selected too.
Type or format once — it lands on every grouped sheet
Add the header in A1, widen the columns, or bold the totals. One action, repeated automatically across the whole group. You should see the [Group] marker in the title bar while you work.
Print the whole group (optional)
Press Ctrl+P (or ⌘+P on Mac) while grouped — Excel includes every sheet in the group in one print job. Great for printing a whole set of identical templates.
Ungroup before you touch a single sheet
Click any tab that is not in the group, or right-click a grouped tab → Ungroup Sheets. Get this habit right and you'll never accidentally overwrite data.
What Actually Happens While Grouped
Grouping syncs your actions, not your data. Here's what carries across every grouped sheet:
| Action | Syncs? | Note |
|---|---|---|
| Type into a cell | ✅ Yes | Same text enters the same cell on every sheet |
| Formatting | ✅ Yes | Bold, fill color, borders, fonts — all applied together |
| Row / column changes | ✅ Yes | Resizes, inserts, and deletes repeat across the group |
| ✅ Yes | All grouped sheets print in one go | |
| Paste copied cells | ✅ Yes | Pasted content goes to the same range on every sheet |
| Cross-sheet formulas | ❌ No | For totals across sheets use 3D refs like =SUM(Sheet1:Sheet3!A1) |
How Do You Ungroup Worksheets in Excel?
Just as easy as grouping — pick one of these:
- Click any tab not in the group — instantly drops the whole group.
- Right-click a grouped tab → Ungroup Sheets — clears the group without switching sheets.
- Windows shortcut: press
Ctrl+Shift+Kto ungroup everything.
Common Questions About Grouping Worksheets
Keep Your Workbook Safe & Organized
The Full Grouping Guide
More detail on multi-select, synced operations, and visual confirmation of groups.
Read the Full Guide →Protect a Worksheet
Lock cells and prevent accidental edits once you've set up your grouped templates.
Protect Sheets →Ungroup & Unprotect
Already grouped or locked and need out? Learn every way to turn both off.
Ungroup Sheets →Continue Exploring
Sources & References
This guide was fact-checked against Microsoft's official Excel documentation.
Disclaimer: This guide is for informational and educational purposes only. Always back up your workbook before batch operations. Last Updated: September 2, 2026.