Group Worksheets - Microsoft Support

Skip to main content Sign in with Microsoft Sign in or create an account. Hello, Select a different account. You have multiple accounts Choose the account you want to sign in with. Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016 Microsoft Office Microsoft365.com

You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are made in all the other worksheets in the group in the exact same location on the worksheets. If you want to create, for example, standard tables or calculations on a large number of worksheets, grouping can save you a lot of time. This works best if the worksheets already have identical data structures.

In this article

• Group selected worksheets

• Ungroup selected worksheets

• Group all worksheets

• Ungroup all worksheets

Group selected worksheets

In the example below, a workbook has multiple worksheets for different cities. All the worksheets have identical structures showing sales of coffee drinks.

To perform the same tasks for a particular set of worksheets, follow these steps:

1. Press and hold down the Ctrl key and select the worksheet tabs you want to group.

   

   Tip: If you want to group consecutive worksheets, select the first worksheet tab in the range, press and hold the Shift key, and then select the last worksheet tab in the range.

2. Now, suppose you want to add the same formula to cell B7 on both the "Paris" and "London" worksheets. When grouped, the change will happen on both worksheets when either worksheet is modified. For example, a formula change to the "Paris" worksheet is automatically made to the "London" worksheet:

   

   Note: When you group worksheets, the name of the workbook changes to include Group.

Ungroup selected worksheets

If you don't want to apply specific tasks to a particular set of worksheets, ungroup selected worksheets.

• Press and hold the Ctrl key and select the worksheet tabs you want to ungroup.

Group all worksheets

You can easily group all the worksheets in a workbook.

1. Right-click any worksheet tab.

2. Click Select All Sheets.

   

   Note: When you group all worksheets, browsing through the worksheets ungroups them. You can browse through the grouped worksheets without ungrouping them if you don't select all worksheets.

Ungroup all worksheets

When you've made all the changes, you can ungroup the worksheets.

1. Right-click any worksheet tab in the group.

2. Select Ungroup Sheets.

   

   Tip: To ungroup all worksheets, you can also select any worksheet tab outside the group.

See Also

Enter data manually in worksheet cells

Need more help?

Want more options?

DiscoverCommunity

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders

Was this information helpful?

Yes No Thank you! Any more feedback for Microsoft? Can you help us improve? (Send feedback to Microsoft so we can help.) What affected your experience? Resolved my issue Clear instructions Easy to follow No jargon Pictures helped Other Didn't match my screen Incorrect instructions Too technical Not enough information Not enough pictures Other Any additional feedback? (Optional) Submit feedback By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×