You can quickly perform tasks on numerous worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any switches you make on one worksheet are made ter all the other worksheets te the group te the precies 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 loterijlot of time. This works best if the worksheets already have identical gegevens structures.
Te this article
Group selected worksheets
Te the example below, a workbook has numerous worksheets for different cities. All the worksheets have identical structures displaying sales of coffee drinks.
To perform the same tasks for a particular set of worksheets, go after the steps below.
Press and hold down the Ctrl key, and click the worksheet tabs you want to group.
Peak: If you want to group consecutive worksheets, click the very first worksheet tabulator te the range, press and hold the Shift key, and click the last worksheet tabulator ter the range.
Now, suppose you want to add the same formula to cell B7 on both the “Paris” and “London” worksheets. When grouped, the switch will toebijten on both worksheets when either worksheet is modified. For example, a formula switch to the Paris worksheet is automatically made to the London worksheet:
Note: When you group worksheets, the name of the workbook switches to include [Group].
Peak: Customers like tips. When you have a good peak to share, include it.
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 click the worksheet tabs you want to ungroup.
Group all worksheets
You can lightly group all the worksheets te a workbook.
Right-click any worksheet tabulator.
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 switches, you can ungroup the worksheets.
Right-click any worksheet tabulator ter the group.
Click Ungroup Sheets.
Peak: To ungroup all worksheets, you can also click any worksheet tabulator outside the group.