To group sheets in Excel, click the first sheet tab, hold Ctrl and click each additional tab (or hold Shift and click the last tab for a contiguous range), and the title bar shows [Group]. To ungroup, right-click a grouped tab and choose Ungroup Sheets, or click a tab outside the group.
Grouping sheets in Excel is one of those features that looks trivial until the day you need to apply the same change to twelve worksheets at once. Hold Ctrl, click each tab you want, and, as Microsoft documents it, data you enter or edit on the active sheet appears in the same cell location on every grouped sheet. Type a header in row 1 or enter a SUMIF formula in B20 and it lands on every tab in the group at the same time.
For monthly reports, weekly time sheets, regional sales workbooks, and budget templates that span dozens of nearly identical pages, grouping saves you from a half hour of repetitive clicking and the kind of mistakes that show up only when a manager spots a 2024 header on the May 2026 tab.
The catch is that almost nobody learns this feature properly. People click Ctrl-tab a few times, make their edits, then forget to ungroup and accidentally type a 30-row VLOOKUP into every other worksheet in the file. The result is a corrupted workbook, a frustrated team, and a half hour of Ctrl+Z hoping the undo stack goes back far enough.
This guide walks you through the right way to group sheets, the right way to ungroup, the keyboard shortcuts, the formatting tricks, the formula tricks, and the warnings nobody told you about the first time you tried to use this feature in a live spreadsheet. Note that Microsoft documents this feature for desktop Excel; Excel for the web does not support selecting multiple sheets.
By the time you finish reading you'll know how to group contiguous tabs with a single Shift-click, group non-contiguous tabs with Ctrl-click, group every sheet in the workbook with a right-click, fill data across grouped sheets with the Fill Across Worksheets command, and ungroup safely so you never overwrite a tab you forgot was still selected. We'll also cover what does and does not replicate when sheets are grouped (typed data and formulas do; copying and pasting between grouped sheets is restricted), and the half dozen scenarios where grouping is the wrong tool and you should reach for 3D references, Power Query, or Power Pivot instead.
Start with the basics. Open the workbook, look at the tab strip along the bottom of the screen, and identify which sheets you want to group. The simplest case is grouping every sheet in the workbook: right-click any tab and choose Select All Sheets from the context menu.
Excel groups every worksheet in the workbook, and the title bar at the top of the window shows Group after the file name. Any edit you make from this moment forward will apply to every sheet at once. If you want to ungroup, right-click any tab and choose Ungroup Sheets, or click a tab that is not currently in the group, which immediately deselects the others.
For grouping a subset of sheets, you have two options depending on whether the sheets you want are next to each other or scattered throughout the tab strip. If they're contiguous, January, February, March, April, all sitting side by side, click the first tab, hold the Shift key, and click the last tab. Excel selects every tab between the two clicks, including both endpoints. This is the same Shift-click range-selection logic that works in Windows Explorer, Outlook, and most other Microsoft applications, so the muscle memory is already familiar.
If the sheets you want are scattered, January, March, June, and December, you need to use Ctrl-click instead. Click the first tab to make it active, then hold the Ctrl key (Command on Mac) and click each additional tab one at a time. Each Ctrl-click toggles a tab into or out of the group, so if you accidentally Ctrl-click the wrong tab, just Ctrl-click it again to remove it. This is the most flexible way to build a custom group and is the technique you'll use most often once you get past simple month-to-month workbooks.
The cue Microsoft documents is in the title bar at the top of the application window: when multiple sheets are selected, the word Group appears after the file name, for example SalesReport.xlsx - [Group]. Selected tabs are also usually highlighted differently from unselected ones in the tab strip, but the exact look varies by Excel version and theme, so treat the title bar as the reliable signal. If you don't see Group in the title bar, only the current sheet is selected and your edits will only apply to it.
Once sheets are grouped, the question is what actually replicates. Microsoft's documentation says that data you enter or edit in the active worksheet appears in all selected sheets, in the exact same location. That covers typed values and formulas; in practice, formatting and page setup changes made while sheets are grouped also apply across the group, but Microsoft does not publish a complete list, so verify anything beyond data entry.
Because edits land in the same cell on every grouped sheet, this is enormously useful for setting up consistent monthly templates: build out the January sheet with all your formulas, formatting, and layout, then group all twelve months and apply identical structure with a single round of edits.
Microsoft does not list which actions do not replicate, but it does document one firm restriction: data that you copy or cut in grouped sheets cannot be pasted onto another sheet, because the copy area spans all the selected sheets. Sheet-level actions such as renaming a tab are not cell edits, and objects such as charts or pictures are best checked sheet by sheet rather than assumed to replicate.
If you need a chart on every sheet, build it once, then copy and paste it into the other sheets after ungrouping. Macros can be programmed to apply to grouped sheets, but the default behavior in the Excel object model only touches the ActiveSheet, so VBA developers need to explicitly loop through ActiveWindow.SelectedSheets.
Formulas behave in an interesting way. When you type a formula in a grouped sheet, the formula text is copied to every grouped sheet, but the references stay relative to each individual sheet. Type =SUM(B2:B10) in cell B11 of the January tab while February and March are grouped, and Excel writes =SUM(B2:B10) into cell B11 of February and March as well, but each one sums the values on its own sheet, not the January sheet's values.
This is exactly what you want for monthly totals and rolling templates. If you need formulas that aggregate across sheets, you don't want grouping at all, you want 3D references like =SUM(January:March!B11), which is a separate Excel feature that does not require sheets to be grouped.
Right-click any tab and choose Select All Sheets from the context menu. Excel groups every worksheet in the workbook in a single action. The fastest method when you want every tab in the file affected by the same edits, perfect for setting up identical headers, footers, or print settings across an entire reporting workbook.
Click the first tab in your desired range, then hold Shift and click the last tab. Excel selects every worksheet between the two endpoints, including both. Useful for grouping months that sit consecutively in the tab strip, like Q1 (January, February, March) or any other side-by-side range that follows the natural order.
Click the first tab to make it active, then hold Ctrl and click each additional tab one at a time. Each Ctrl-click toggles a tab in or out of the group, giving you full custom control. Use this when you need to apply changes to a scattered subset of sheets, like only the regional sheets, only the months that ended in a holiday week, or any other arbitrary selection.
Right-click any grouped tab and choose Ungroup Sheets, or simply click a tab that is not currently in the group. Either action immediately deselects every grouped tab and removes the [Group] indicator from the title bar. Ungrouping immediately after you finish your batch edit is the single most important habit to develop, it prevents accidental edits from propagating later.
After grouping sheets, you can also use Home tab > Editing > Fill > Across Worksheets to copy specific content from the active sheet to all grouped sheets after the fact. Choose All to copy content and formatting, Contents to copy just values and formulas, or Formats to copy just the formatting. Useful when you've already done your edits and decide later that you want to push them to additional sheets.
The Fill Across Worksheets command deserves a deeper look because it solves a problem that catches new users off guard. Normal grouping only replicates edits made after you group the sheets. If you've already made changes on the January tab, then group February and March, those existing changes don't magically appear on February and March until you tell Excel to replicate them.
That's where Fill Across Worksheets comes in. Group your sheets first, click the source cell or range on the active sheet, then go to Home > Editing > Fill > Across Worksheets, choose what to copy (All, Contents, or Formats), and click OK. Excel pushes the selected cells from the active sheet to every grouped sheet, overwriting whatever was previously in those cells.
For batch formatting work, the workflow that scales best is: open the workbook, build out the master template on one sheet, group all the target sheets including the master, select the cells you want to push out, run Fill Across Worksheets with the All option to copy content and formatting together, then ungroup immediately.
This sidesteps the temptation to start editing while everything is grouped and minimizes the chance of an accidental change replicating to sheets you didn't mean to touch. If you find yourself doing this kind of batch templating regularly, build a starter workbook with the master template already set up and just save copies under new names for each project.
One source of confusion is when grouping sheets does not behave the way users expect because the workbook has protected sheets or hidden sheets. Microsoft notes that this approach may not work with protected or hidden sheets. A protected sheet may not accept edits, and hidden sheets are not visible in the tab strip, so you cannot click them into a group.
If you have a mixed workbook with some protected, some hidden, and some active sheets, the safest workflow is to unprotect everything you need to edit, unhide everything you need to group, do your batch edit, then restore protection and hidden status afterward.
Right-click any tab and choose Select All Sheets to group every worksheet in the workbook in one action. This is the fastest method when you want to apply page setup, headers and footers, or a consistent header row across every tab. Remember to ungroup immediately after the batch edit by right-clicking and choosing Ungroup Sheets, otherwise future edits will continue to replicate.
Click the first tab, hold Shift, click the last tab to group a contiguous range of worksheets. Excel selects every tab between the two endpoints including both. Ideal for grouping Q1 sheets (Jan, Feb, Mar) or any side-by-side block. If you accidentally include too many tabs, Shift-click a different ending tab to expand or contract the selection without starting over.
Click the first tab, hold Ctrl (Command on Mac), then click each additional tab to build a custom group of scattered worksheets. Each Ctrl-click adds or removes a tab from the group, so you can toggle individual sheets in and out as you build your selection. Most flexible method, ideal for grouping only specific regional sheets or only the months your team needs to update.
Group your sheets first, then select the source cells on the active sheet and run Home > Editing > Fill > Across Worksheets. Choose All to push content and formatting, Contents for just values and formulas, or Formats for just the visual styling. This is the right command when you've already entered data on one sheet and want to replicate it to others after the fact without retyping.
Right-click any grouped tab and choose Ungroup Sheets, or click any tab that is not currently in the group. Both actions remove the [Group] indicator from the title bar and stop further edits from replicating. Develop the habit of ungrouping immediately after every batch edit, this single discipline prevents the most common cause of corrupted multi-sheet workbooks: forgotten group selections.
Keyboard shortcuts speed everything up. Ctrl+Page Down moves to the next sheet, Ctrl+Page Up moves to the previous sheet, both of which work even while sheets are grouped. To select the next sheet and add it to the group, hold Ctrl+Shift+Page Down, and Ctrl+Shift+Page Up adds the previous sheet to the group.
These shortcuts let you build a contiguous group entirely from the keyboard without ever touching the mouse, which is useful when your tab strip is so wide it scrolls off screen and clicking individual tabs becomes annoying. On a Mac, Microsoft lists Ctrl+Page Down or Option+Right Arrow for the next sheet, and Ctrl+Page Up or Option+Left Arrow for the previous sheet.
Microsoft's steps for Select All Sheets and Ungroup Sheets use the tab right-click menu (the keyboard route is F6 to reach the tabs, arrow keys to move, and Ctrl+Space to select each tab), but you can also add both commands to the Quick Access Toolbar. Right-click the QAT, choose Customize Quick Access Toolbar, set Choose Commands From to All Commands, scroll down to Select All Sheets, add it, then do the same for Ungroup Sheets. Once they're on the QAT, you can press Alt+1, Alt+2, etc., depending on their position, to trigger them instantly.
For navigating large workbooks with dozens of tabs, the tab strip itself has hidden controls many users miss. Right-click the navigation arrows in the lower-left corner of the tab strip and Excel opens a dialog listing every sheet in the workbook, click any name to jump there directly. This works whether or not sheets are grouped and is much faster than scrolling through the tab strip when you have 30+ tabs. Combined with grouping, the navigator dialog turns a workbook with 50 monthly tabs into a manageable one-click destination instead of a horizontal scrolling marathon.
For folks doing a lot of cross-tab work like this, building speed in Excel pays back fast in any office job that involves spreadsheets, and brushing up on the basics with structured practice helps. Test prep resources like the Microsoft Excel Workbook and Worksheet Management Questions and Answers drill exactly these multi-sheet operations along with named ranges, freezing panes, and protecting structure, the same content that shows up on MOS Excel Expert certification and most temp-agency proficiency tests.
These sheet shortcuts are listed in Microsoft's Excel keyboard shortcut reference for Windows.
| Goal | Windows shortcut | Result |
|---|---|---|
| Move to the next sheet | Ctrl+Page Down | Activates the next worksheet in the workbook |
| Move to the previous sheet | Ctrl+Page Up | Activates the previous worksheet in the workbook |
| Select the current and next sheet | Ctrl+Shift+Page Down | Adds the next sheet to the selection (a group) |
| Select the current and previous sheet | Ctrl+Shift+Page Up | Adds the previous sheet to the selection (a group) |
Beyond the basics, there are a few advanced patterns worth knowing. Grouping sheets to set up identical print settings is one of the most underused applications of this feature.
Group your monthly tabs, go to Page Layout > Page Setup, set the orientation to landscape, set the print area to A1:M50, configure the header and footer with the month name pulled from cell A1, set rows to repeat at the top, set the print quality, and every grouped sheet inherits the same print configuration in a single round of clicks. Without grouping, you'd be doing this twelve times for a yearly workbook, more if your reporting spans regions or product lines.
Grouped sheets also play nicely with named ranges, which is a powerful combination for templates. Set up named ranges on the master sheet, group all the target sheets, copy and paste the cells with the named ranges, and you'll end up with consistent named references on every tab. Check each name's scope in the Name Manager afterward, since a name can be scoped to the whole workbook or to a single worksheet, and a duplicate name in the same scope will collide.
Conditional formatting rules can behave unexpectedly across grouped sheets if your data layout differs slightly between tabs. Test the conditional formatting on one or two tabs after pushing it out before assuming everything works as expected. If the layouts differ, use Format Painter on individual sheets instead of grouping, or rebuild the conditional formatting rule on each tab to reference the correct relative location.
There are a few situations where grouping sheets is the wrong tool and you should reach for a different feature. The first is aggregating data across multiple sheets. If you want a single cell that adds up the same cell from every monthly tab, like =SUM(January:December!B5), that's a 3D reference, not a grouping operation. 3D references don't require sheets to be grouped, they work directly in formulas, and they're faster and safer for any kind of cross-sheet aggregation. You can also use 3D references with AVERAGE, COUNT, MIN, MAX, and a handful of other functions that natively support them.
The second wrong-tool scenario is when you need different but related layouts on each sheet, like a sales workbook where each region has its own product mix. Grouping forces every change to be identical, which means you either end up with the wrong products on the wrong tabs or you have to ungroup constantly to make sheet-specific tweaks.
For this kind of work, the right tool is Power Query or a master data table with Power Pivot, both of which let you maintain a single source of truth and generate per-region views dynamically. Setting up Power Query is a longer-term investment than learning to group sheets, but the payoff is enormous for any team that produces recurring multi-sheet reports.
The third scenario is when you need true real-time synchronization between sheets, not just a one-time batch edit. Grouping is a snapshot operation, you make the edit, the edit replicates, you ungroup, and from that moment on each sheet evolves independently. If you need sheet B to always show whatever is currently in sheet A, link the cells with formulas like =SheetA!A1, which dynamically pulls the latest value. Combine cell linking with named ranges and Indirect functions for advanced templates that update automatically as the source data changes.
Beyond the standard grouping workflow, Excel power users develop a few signature patterns. The first is the master-template grouping pattern: set up a single master template sheet, name it Template or hide it as a hidden sheet that lives at the start of the workbook, then duplicate it for each new period, region, or category.
When you need to update the structure, you unhide the master, ungroup everything, make your edits on the master, then group all the active tabs and Fill Across Worksheets to push the master's content out. This protects you from having any one sheet drift into a different layout while still letting you batch-update the whole workbook on demand.
The second pattern is the audit-on-group trick. Before grouping a large number of sheets, open the Name Manager (Ctrl+F3), scan for any names that might cause collisions, and check Data > Data Validation > Circle Invalid Data on the master to confirm no broken rules will replicate. After grouping and editing, run Formulas > Error Checking on the active sheet to verify nothing replicated incorrectly. Build these checks into your workflow and you'll catch issues before they hit a stakeholder review.
The third pattern is the macro-friendly group, where you wrap repetitive grouped-sheet operations into a tiny VBA macro that handles the grouping, the edit, and the ungrouping in one shot. Two lines of code: ActiveWindow.SelectedSheets.Select after defining the sheets array, and an explicit Worksheets(1).Select at the end to deselect. This is overkill for a one-time edit but pays off hugely when you're doing the same multi-sheet update every Monday morning. Combine with a custom QAT button or a workbook-level shortcut and the entire operation collapses into a single keystroke.
Click the first tab, hold Ctrl (Command on Mac), and click each additional tab you want to include. Or hold Shift and click the last tab to group a contiguous range. Right-click any tab and choose Select All Sheets to group every tab in the workbook at once. The title bar will show [Group] to confirm grouping is active. This works in desktop Excel; Excel for the web does not support selecting multiple sheets.
The [Group] indicator after the file name in the Excel title bar means two or more worksheets are currently grouped together. Data you enter or edit on the active sheet, such as typed values and formulas, appears in the same cells on every other sheet in the group. Always check this indicator before typing to avoid accidental cross-sheet edits.
Right-click any grouped tab and choose Ungroup Sheets from the context menu. Alternatively, click any tab that is not currently part of the group, which immediately deselects every grouped tab. Either action removes the [Group] indicator from the title bar and stops further edits from replicating to other worksheets in the workbook.
Your worksheets are still grouped. Excel shows [Group] in the title bar while the group is active. Right-click any tab and choose Ungroup Sheets to stop the replication, then check each sheet and use Undo (Ctrl+Z) right away, or close without saving and reopen the last good copy, because Microsoft notes that sheets saved while grouped stay grouped when the workbook is reopened. Ungroup immediately after every batch edit so this does not happen again on your next workbook.
Yes. When you enter a formula in a grouped sheet, Excel writes the same formula to every grouped sheet but each formula references that sheet's own cells, not the original sheet's cells. For example, =SUM(B2:B10) in cell B11 of the January tab while February and March are grouped becomes =SUM(B2:B10) on each tab, summing each sheet's own data.
Grouping sheets replicates edits across multiple worksheets simultaneously, which suits setup and batch formatting. A 3D reference such as =SUM(January:December!B5) aggregates the same cell from a range of sheets into one result, which suits totals across tabs. Use grouping for layout work and 3D references for aggregating data; they are separate features.
Grouping is available in desktop Excel for Mac as well, generally using Command in place of Ctrl for non-contiguous tabs and Shift for a contiguous range; check Microsoft's Mac instructions for exact menu wording. Sheet-navigation shortcuts differ: Microsoft lists Ctrl+Page Down or Option+Right Arrow for the next sheet, and Ctrl+Page Up or Option+Left Arrow for the previous one.
Group all the destination sheets first by Ctrl-clicking their tabs, then select the source cells on the active sheet, and go to Home > Editing > Fill > Across Worksheets. Choose All to copy both content and formatting, Contents for values and formulas only, or Formats for visual styling only. Click OK and Excel pushes the selection to every grouped sheet.
Grouping sheets in Excel is a deceptively simple feature with outsize impact on how fast you can build, format, and maintain multi-sheet workbooks. The actual mechanics take two minutes to learn: Ctrl-click for custom groups, Shift-click for contiguous ranges, right-click for Select All Sheets, watch for the [Group] indicator in the title bar, and ungroup immediately after every batch edit by right-clicking and choosing Ungroup Sheets. Master those five moves and you'll handle every common grouped-sheet workflow without ever damaging a workbook by accident.
The deeper skill is knowing when grouping is the right tool and when it isn't. Reach for grouping when you need identical setup or formatting on many similar tabs, when you're building out a monthly or weekly template, when you need to push print settings or page layouts uniformly across a reporting workbook.
Reach for 3D references when you need to aggregate data across sheets, reach for cell linking when you need dynamic synchronization, reach for Power Query or Power Pivot when you're managing genuinely different but related datasets that should share a single source of truth. Each tool has its place, and the Excel user who knows all four moves at the right time runs circles around the one who only knows grouping.
Put what you've learned into practice on a workbook you already use. Open a monthly reporting file or a weekly time sheet template, identify three or four formatting or layout improvements you'd like to make across every tab, group the sheets, push the changes through, ungroup, and verify the results. The first time you save thirty minutes of repetitive clicking with a single grouped edit, the feature stops being a curiosity and becomes a permanent part of how you work in Excel.