To edit several worksheets at once in Excel for Microsoft 365 on Windows, select their tabs with Ctrl-click (or select a consecutive range with Shift-click), then make the change on the active sheet. Excel applies supported edits to the corresponding cells or areas on every selected sheet; right-click a selected tab and choose Ungroup Sheets when you are finished.
What grouping worksheets means
Grouping worksheets temporarily links selected sheet tabs so that an action made on one selected sheet is also made on the others. It is useful when separate tabs share a layout—for example, one worksheet for each month, branch, class, or department. If every monthly sheet has a total in cell F20, you can format F20 on the grouped sheets in one operation instead of repeating the same steps twelve times.
Grouping does not combine worksheets into one, merge their data, or create a permanent relationship between them. Each sheet remains separate, with its own values and formulas. The group is a temporary selection state, not a new kind of workbook or a substitute for consolidating data.
This is also different from grouping rows or columns, which collapses and expands parts of an outline, and from grouping shapes or objects, which makes several visual items act as one. Those features do not edit matching cells across worksheets.
How to group sheet tabs
- Save the workbook, especially if you are about to make a broad formatting or data change.
- Find the worksheet tabs along the bottom of the Excel window. If the sheets are next to each other, click the first tab, hold Shift, and click the last tab. Excel selects the tabs between them.
- For sheets that are not next to each other, hold Ctrl and click each tab you want to include. On a Mac, use Command-click for separate tabs and Shift-click for a consecutive range.
- Check which tabs are selected before editing. Excel may show the word [Group] in the title bar, and the selected tabs are visually highlighted. The active sheet is the one currently displayed.
To select every worksheet in the workbook, right-click any sheet tab and choose Select All Sheets. Use this carefully: a change intended for two monthly sheets could otherwise affect every tab. If a sheet is hidden, it cannot be selected by clicking its tab; unhide it first if it needs to be part of the group.
What you can edit while sheets are grouped
Many routine worksheet actions can be applied to the same location on each selected sheet. For example, you can type or clear entries, apply cell formatting, adjust row heights or column widths, and make similar layout changes. The important idea is that Excel repeats the action at the corresponding location, not that it compares the content of the sheets and decides what should change.
Suppose the workbook has tabs named January, February, and March, each with product names in A2:A15 and sales figures in B2:B15. If you group those three tabs and apply a number format to B2:B15, the corresponding range on all three sheets receives that format. If you type a heading in A1 on the active sheet, Excel enters it in A1 on the other grouped sheets too.
Grouped editing is most reliable when the worksheets use the same template: the same labels, row order, and cell positions. If one sheet has an extra header row, editing cell B5 across the group may change different kinds of information on different sheets. Grouping follows cell addresses; it does not match rows by their labels.
How formulas and references behave
When you enter a formula in a cell while sheets are grouped, Excel places a formula in that cell on each selected sheet. A relative reference in the formula is interpreted within each sheet. For instance, if the same formula is entered in C2 on three grouped worksheets, a reference to A2 on that sheet refers to A2 of each individual worksheet, rather than directing all three formulas to one sheet.
This can be handy for a repeated template, but it can also create an unnoticed error when the sheets are not structurally identical. A formula copied into the same address may refer to a blank cell or an unrelated field on one tab. Before entering or filling formulas across a group, verify the layout and inspect the results on more than one sheet.
Do not assume grouping makes separate sheets share a live value. If you later change a value on January, that does not automatically update February just because the two sheets were once grouped. The grouping operation repeats edits at the time you make them; it does not keep the sheets synchronized afterward.
A safe workflow for repeated changes
Use a small, deliberate sequence when editing a group, especially in a workbook used by other people:
- Confirm that every chosen sheet should receive the same edit and that the relevant cells mean the same thing on every sheet.
- Save a copy or save the workbook before making a change that would be tedious to reverse.
- Group only the intended tabs, then verify the selection and active sheet.
- Make one change and check a second selected sheet to confirm the result is appropriate.
- Ungroup the sheets immediately after the shared edits, before continuing with sheet-specific work.
For a high-impact operation, such as clearing a range or replacing entries, consider testing on a duplicate workbook first. Undo can reverse many ordinary edits, but it is not a substitute for checking the selected tabs before acting. A save made after an unintended grouped change can also make recovery more complicated.
How to ungroup sheets and spot a forgotten group
To end grouped editing, right-click one of the selected sheet tabs and choose Ungroup Sheets. You can also click a worksheet tab that is not part of the group. If every worksheet is selected, clicking an individual tab generally returns the workbook to a single-sheet selection; using the right-click command makes the action explicit.
Ungroup as soon as the shared task is complete. If tabs remain grouped, ordinary actions you intended for the current worksheet—such as typing into a cell or applying a format—may be repeated on the other selected sheets. A grouped state is easy to miss when several tabs look highlighted, so check the title bar and tab selection if an edit appears in more than one place.
Common problems and limitations
- The wrong tabs changed: More sheets were selected than intended, or the workbook was set to Select All Sheets. Undo promptly if appropriate, then inspect the tabs before trying again.
- The same edit causes different results: The worksheets do not share the same layout. Compare their row and column structure, and edit sheets separately if corresponding cells have different meanings.
- You cannot see a sheet tab: The sheet may be hidden, or the tab area may be crowded. Use the sheet navigation controls to move through visible tabs; unhide a hidden sheet if you need to select it.
- You expected edits to stay connected: Grouping is not ongoing synchronization. Later changes on one sheet do not automatically flow to the others.
Grouping is intended for parallel edits, not for every multi-sheet task. For example, it does not itself combine monthly transactions into an annual report. It can also be risky when sheets have exceptions, different row orders, or formulas with different purposes. In those cases, review and edit each sheet separately, or use an appropriate data-consolidation method for the reporting task.
Alternatives when sheets do not match
If only a few cells need the same value, editing each sheet individually may be safer than grouping. This takes longer but lets you confirm the location and meaning on each tab. If the sheets have the same layout but you need to apply one cell’s contents to another sheet, a cross-sheet formula or a deliberate copy-and-paste may fit better; those methods have different effects and should not be confused with grouping.
For repeated reports, a consistent template is often the best long-term fix. Standardize the same fields in the same rows and columns across the worksheets, then use grouping for genuinely shared formatting or entries. If your real goal is to analyze records from many tabs together, consider organizing the data into one table with a field identifying the month or department. A single structured dataset is easier to filter, summarize, and report on than many sheets that must be kept aligned by hand.
Frequently Asked Questions
How do I edit multiple sheets at once in Excel?
Ctrl-click the tabs you want on Windows, or Shift-click the ends of a consecutive range, then make the edit on the active sheet. Excel repeats supported changes at corresponding locations on the grouped sheets. On a Mac, use Command-click for separate tabs.
Can I group non-adjacent worksheets?
Yes. Hold Ctrl on Windows and click each tab to include; on a Mac, hold Command while clicking. Check the selected tabs before editing, since only the sheets you select are intended to receive the change.
How do I stop editing grouped sheets?
Right-click a selected worksheet tab and choose Ungroup Sheets. You can also select a tab outside the group. Confirm that only one sheet is selected before making a sheet-specific edit.
Will changing a cell in one grouped sheet permanently update the others?
No. Grouping repeats an edit across selected sheets while they are grouped; it does not link their contents afterward. A later change to one worksheet does not automatically change the same cell on the others.
Can I group every worksheet in a workbook?
Yes. Right-click a sheet tab and choose Select All Sheets. Because this includes all worksheets, check carefully before typing, clearing cells, or changing formatting. Choose Ungroup Sheets when finished.
Related
- Convert XLS to Excel: How to Save as an XLSX Workbook
- Convert XML to Excel: Import, Clean, and Save Data
- Convert ZIP to Excel: What Works and What Does Not
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Freeze Panes: Keep Top Rows and Side Columns VisibleYes. To keep Excel’s top row and a side column visible at the same time, select the cell…
- Excel Reverse Lookup with Multiple Criteria: How-ToTo perform a reverse lookup with multiple criteria in Excel, use the INDEX and MATCH functions together, or…
- Cancel a Scheduled Email in OutlookTo cancel a scheduled email in Outlook, find it in Drafts (new Outlook, Outlook on the web, or…
- How to Create a Signature Line in OutlookTo create an email signature in Outlook, open the signature settings for your version of Outlook, add your…
- Excel Keyboard Shortcut to Hide a ColumnIn Excel for Microsoft 365 on Windows, select one or more column headers and press Ctrl+0 to hide…
- How to Open an IIF File in Excel Without Losing DataTo open an IIF file in Excel, import it as a tab-delimited text file rather than double-clicking it.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.