What grouping worksheets means and why you'd do it
Grouping worksheets in Excel means selecting multiple sheet tabs at the bottom of your workbook and treating them as one unit. When sheets are grouped, any action you take — like hiding them, moving them, or changing their color — happens to all of them at once instead of one at a time.
You group worksheets when you have related data spread across multiple sheets and want to manage them together. For example, if you have separate sheets for January, February, and March sales data, grouping them lets you hide all three at once, or print all three with the same settings in a single step. It saves time when you're working with 5, 10, or 20 similar sheets.
Grouping is temporary — the sheets stay grouped only while you're working. Once you ungroup them or close the file, the grouping is gone. This is different from moving or deleting sheets, which are permanent changes.
Key Takeaways
- Right-click any sheet tab and choose "Select All Sheets" to group every sheet in your workbook at once, or hold Ctrl and click individual tabs to group only the ones you want.
- When sheets are grouped, the tabs turn white and the sheet names appear bold, so you can see at a glance which sheets are selected.
- Any formatting or action you perform — hiding, unhiding, moving, renaming, or changing tab color — affects all grouped sheets simultaneously.
- Ungroup sheets by right-clicking any tab and choosing "Deselect All Sheets", or by clicking a single sheet tab while holding no keys.
- Grouping does not merge the data in your sheets; it only lets you manage multiple sheets as a single unit for display and printing purposes.
How to select and group sheets using the sheet tabs
The sheet tabs are the clickable labels at the bottom left of your Excel window. Each tab shows the name of one worksheet. To group sheets, you select multiple tabs using your mouse and keyboard.
To group all sheets in your workbook at once, right-click any sheet tab and select "Select All Sheets" from the menu. Every tab will turn white and the text will appear bold. This is the fastest method if you want to work with every sheet in the file.
To group only some sheets, hold down the Ctrl key on your keyboard and click each sheet tab you want to include. Click the first tab, keep Ctrl pressed, then click the second tab, the third tab, and so on. Each tab you click will turn white and bold. You can group sheets that are next to each other or scattered throughout your workbook — Ctrl works either way.
If the sheets you want are all in a row with no gaps, you can also click the first sheet tab, hold Shift, and click the last sheet tab. Excel will select that first sheet, the last sheet, and every sheet in between. This is faster than Ctrl-clicking when you have many consecutive sheets to group.
What you can do with grouped sheets
Once sheets are grouped, most actions you perform apply to all of them. The most common use is hiding multiple sheets at once. Right-click any grouped sheet tab, select "Hide", and all the grouped sheets disappear from view. The tabs vanish from the bottom of the window, but the sheets are still in your file — they are just not visible.
You can also move grouped sheets together. Right-click any grouped tab and choose "Move or Copy Sheet". Excel will move all the grouped sheets to the location you specify, keeping them in their original order relative to each other. This is useful when you want to reorganize a workbook and keep related sheets together.
Changing the tab color works on grouped sheets too. Right-click any grouped tab, select "Sheet Tab Color", and pick a color. All the grouped sheet tabs will change to that color at once. This helps you visually organize your workbook — for example, making all sales sheets blue and all expense sheets red.
You can also rename grouped sheets, though this is rarely useful because each sheet needs its own name. If you rename a grouped sheet, only that one sheet is renamed, not all of them.
How to ungroup sheets
To ungroup sheets, right-click any sheet tab and select "Deselect All Sheets". All the tabs will return to their normal gray color and the bold text will disappear. The sheets are still there and nothing has changed — you have just stopped treating them as a group.
You can also ungroup by clicking any single sheet tab while holding no keys. This selects only that one sheet and automatically deselects all the others. This is the quickest way if you want to go back to working on one sheet at a time.
Hiding and unhiding grouped sheets
When you hide grouped sheets, all of them disappear from the sheet tab bar at the bottom. To hide them, right-click any grouped tab and select "Hide". The tabs vanish immediately.
To unhide grouped sheets, you need to right-click the space where the sheet tabs used to be, or right-click a visible sheet tab next to where the hidden ones were. Select "Unhide" and a dialog box will appear listing all hidden sheets. Click the sheet name you want to show and click OK. The sheet will reappear in the tab bar.
If you have many hidden sheets, you can only unhide one at a time using this method. You cannot unhide multiple sheets in a single step, even if they were grouped when you hid them. Unhide each one separately by repeating the process.
Common mistakes when grouping sheets
The most common mistake is forgetting that sheets are grouped and then making a change you only meant to apply to one sheet. For example, you might delete data from what you think is a single sheet, only to realize the sheet was grouped and you deleted the same data from five sheets. Always check the sheet tabs — if they are white and bold, sheets are grouped.
Another mistake is grouping sheets and then closing the file expecting the grouping to be saved. Grouping is temporary. When you close Excel and reopen the file, the sheets will no longer be grouped. If you need sheets to stay grouped, you will have to select them again the next time you open the file.
Some people also try to group sheets and then edit the data in one sheet, expecting the change to appear in all grouped sheets. Grouping does not link the data — it only links the display and management of the sheets. Changes you make to one sheet do not automatically appear in other sheets, even if they are grouped.
Printing grouped sheets together
When sheets are grouped, you can print all of them in one print job. Open the File menu, select "Print", and look at the print preview. You will see pages from all the grouped sheets. Click "Print" and Excel will print every grouped sheet in order, one after another.
This is useful when you want a single printout that includes data from multiple related sheets. Without grouping, you would have to print each sheet separately and then stack the pages together by hand.
You can also set print options for all grouped sheets at once. For example, if you want all grouped sheets to print in landscape orientation instead of portrait, you can select the sheets, then go to Page Layout and change the orientation. The change will apply to all grouped sheets.
Frequently Asked Questions
Can I group sheets that are not next to each other?
Yes. Hold Ctrl and click each sheet tab you want to group, even if they are scattered throughout your workbook. The sheets do not have to be adjacent. Ctrl-clicking lets you pick any combination of sheets.
If I group sheets and delete data, does it delete from all of them?
No. Grouping only affects display and management actions like hiding, moving, and printing. If you edit the actual data in a cell, that change happens only to the sheet you are currently viewing, not to all grouped sheets. Always make sure you are on the correct sheet before editing data.
What happens to grouped sheets when I save the file?
The grouping is not saved. When you close the file and reopen it, the sheets will no longer be grouped. You will have to select and group them again if you need them grouped for your next work session.
Can I group sheets and then link their data together?
Grouping does not link data. If you want changes in one sheet to automatically appear in another, you need to use formulas that reference the other sheet, not grouping. Grouping is only for managing the display and printing of multiple sheets at once.
How do I know if sheets are grouped?
Look at the sheet tabs at the bottom of the window. If the tabs are white and the sheet names appear in bold text, the sheets are grouped. If the tabs are gray, no sheets are grouped.