Sometimes, it’s useful to perform the same tasks on multiple worksheets. Instead of repeating the same steps, you can group worksheets together, and then make edits just once. This is easy to do, and it only takes a few clicks. Let’s learn how to group sheets in Excel.
How to Group Sheets in Microsoft Excel
Imagine that you have an Excel workbook that contains several worksheets. These are identified by the tabs at the bottom containing the sheet names. Grouping sheets together is useful if you want to make identical edits on multiple sheets at the same time. It’s a very useful time-saving technique.
To group sheets together, you have multiple options. For any, begin by clicking on the first sheet that you want to group together. Then, your next step will vary depending on if you use Excel on Windows or Mac.
On Mac, hold down the Command key on your keyboard. Then, keeping the key pressed down, click on the names of the other sheets that you want to group together. When you’re finished, release the Command key.
You’ll see that all of your selected sheets are now grouped together. To do the same on Windows, simply hold down Control as you click on the sheet names.
Want to select multiple sheets in a row? Save time by clicking on the first sheet, and then hold down Shift on your keyboard. Then, click on the last sheet that you want to group together. Excel will automatically group the full range. This saves you from having to click on each sheet name individually.
Once you’ve finished your bulk edits, you may want to ungroup your sheets. To do that, simply right-click on any of the grouped sheet tabs. Then, from the menu, click on Ungroup Sheets.
They will return to their normal, ungrouped status.
As you can see, it’s easy to group sheets in Excel. This helps you make edits to multiple sheets all at once.