How to Group Sheets in Excel (Edit Them All at Once)
Shift-click or Ctrl-click the sheet tabs and Excel applies every edit to all of them at once. Here is how to group sheets, spot when you are grouped, and ungroup before it costs you.
To group sheets in Excel, click the first sheet tab, then hold Shift and click the last tab to take a consecutive run, or hold Ctrl (Command on a Mac) and click each tab you want individually. Group appears beside the file name at the top of the window, and from that moment anything you type, format or delete lands on every grouped sheet at once.
Knowing how to group sheets in Excel turns twelve identical edits into one. Type a total into B7 and B7 on every sheet in the group gets the same total, in the same cell, with the same formatting.
The catch is that grouping stays switched on until you switch it off. Excel gives you one quiet signal and no warning before an edit spreads. So group only sheets that share a layout: if B7 holds a quarterly total on one sheet and a customer name on another, a grouped edit overwrites both without asking.
How to Group Sheets in Excel, Step by Step
The sheet tabs run along the bottom of the window. Everything below happens there.
1. Click the tab of the first sheet you want. It becomes the active sheet, the one whose cells you are looking at.
2. Add the rest. For a consecutive run, hold Shift and click the last tab in the run; Excel takes everything between the two. For sheets scattered around the workbook, hold Ctrl and click each tab you want, one at a time.
3. Check the top of the window. Microsoft's documentation says Group appears in the title bar once more than one sheet is selected, and the grouped tabs turn white while the rest stay grey. If neither has happened, the selection did not take. Click the first tab again and start over.
4. Make the edit, then ungroup immediately. Right-click any tab in the group and choose Ungroup Sheets, or simply click a tab that is not in the group. Do this before you touch anything else in the workbook.
Select All Sheets, Mac Keys and the Browser Version
Every sheet at once. Right-click any tab and choose Select All Sheets. One quirk comes with it: when every sheet is grouped, clicking any other tab ungroups them, because there is no tab left outside the group. Grouping a subset instead lets you move between those sheets without losing the group.
On a Mac. Shift behaves the same way for a consecutive run, but hold Command rather than Ctrl to pick out individual tabs.
Without the mouse. Microsoft documents a keyboard route: press F6 to move focus to the sheet tabs, use the left and right arrow keys to land on a sheet, then press Ctrl+Space to add it to the selection. Repeat for each sheet you want.
In a browser. Microsoft's Select worksheets page lists Excel for Microsoft 365, Excel 2024 and Excel 2021, and does not list Excel for the web. A Microsoft Q&A answer states the web app cannot select more than one sheet at a time, though that answer dates from 2022 and Microsoft has not published a clear update since. If the tabs refuse to multi-select in your browser, open the workbook in the desktop app and try there.
What Grouping Sheets Does Not Do
It is not the same as grouping rows or columns. That is a different feature in a different place: Data > Outline > Group, which folds ranges of rows or columns into collapsible outlines on a single sheet. The two share a word and nothing else, and searching for one will happily hand you instructions for the other.
It does not combine or merge anything. Grouping writes the same thing to several sheets. It does not pull their data into one place. Consolidating twelve monthly sheets into a summary is a separate job with separate tools.
It does not survive the file. There is no saved group. Close the workbook, reopen it, and the sheets are ungrouped.
It does not stop at typing. Formatting and formulas propagate, and so does inserting or deleting rows and columns from any sheet in the group. That is the point when you mean it, and applying banded row shading across twelve monthly sheets in one pass is exactly what grouping is for. The vendor documentation covers cell edits, formatting and row or column changes; it does not spell out how per-sheet view settings behave in a group, so if you were also planning on freezing a header row, check a second sheet afterwards rather than assuming it carried across.
Common Questions
How do I tell whether sheets are still grouped? Two signals, both easy to miss. Group sits beside the file name at the top of the window, and the grouped tabs along the bottom are white while the ungrouped ones are grey. If you are about to make an edit you would not want duplicated, glance at the tabs first.
Why did my sheets ungroup on their own? They did not. Clicking a tab outside the group ends grouping immediately, which is the intended escape hatch. And if you had used Select All Sheets, moving to any other sheet ungroups everything, because every tab was already in the group.
Can I group sheets from two different workbooks? Every documented route works on the tabs of one workbook. There is no equivalent for selecting sheets across two open files, so edits meant for both have to be made twice or handled another way.
If the Tabs Won't Group
If Shift-click and Ctrl-click simply do nothing, the first thing to check is where the file is open. The browser version is the usual explanation. Open the same workbook in the desktop Excel app and try the same clicks there.
If the problem is that you cannot see the tabs you need, the tab strip is probably too narrow to show them all. Use the arrows to the left of the tabs to scroll through the hidden ones, or the All Sheets menu to jump straight to a sheet by name, then start the selection from there.
And if a grouped edit has already landed somewhere it should not have: ungroup first, before anything else, so you stop adding to it. Then undo. The sheets you did not mean to touch are the ones worth checking, not the one you were looking at.
