Business managers and owners group worksheets in Excel so that changes made to one worksheet apply automatically to all connected worksheets. When you group worksheets together, the tabs at the bottom of Excel turn white to indicate that they’re selected and grouped. Although this feature helps you to update identical data quickly across many worksheets, it can also cause you to accidentally make undesired changes if you forget that you’re working within a group. To prevent errors, Microsoft has designed Excel so that you can effortlessly ungroup tabbed worksheets with keyboard or menu commands. Show
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More...Less 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 worksheetsIn 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 the steps below.
Tip: Customers like tips. When you have a good tip to share, include it. Ungroup selected worksheetsIf you don’t want to apply specific tasks to a particular set of worksheets, ungroup selected worksheets.
Group all worksheetsYou can easily group all the worksheets in a workbook.
Ungroup all worksheetsWhen you’ve made all the changes, you can ungroup the worksheets.
See AlsoEnter data manually in worksheet cells Need more help?How do I group and ungroup worksheets in Excel for Mac?Press and hold down the ⌘ (command) key, and then click on each of the worksheet tabs you want to group. Alternatively, click the first worksheet tab you want to group, press and hold the Shift key, and then click the last worksheet tab to group consecutive worksheets.
How do you ungroup in Excel for Mac?To ungroup, use the shortcut Alt Shift left arrow in Windows and Command Shift J on a Mac. Again, if you only have cells selected, you'll get a dialog, and you'll need to choose wether you want to ungroup rows or columns.
How do you ungroup sheets on a Mac?Group objects: Select multiple objects, then Control-click one of the objects and choose Group from the shortcut menu. Ungroup objects: Control-click the group, then choose Ungroup from the shortcut menu.
How do you group worksheets in Excel on a Mac?Press and hold down the Ctrl key, and click the worksheet tabs you want to group. Tip: If you want to group consecutive worksheets, click the first worksheet tab in the range, press and hold the Shift key, and click the last worksheet tab in the range.
|