This article explains how to group worksheets in Excel. You may want to do this to quickly edit multiple worksheets simultaneously, perform the same calculation on multiple sheets, correct typos, or copy a group of sheets.
To group sheets in Excel:
If you want to group consecutive (adjacent) worksheets, click on the first sheet tab, press and hold thekey, and click the last sheet tab that you want to include in your selection.
When working with grouped worksheets, it is essential to realize that any changes to the active sheet will also affect the rest of the selected worksheets.
In the image above, you can see that the word [Group] is shown next to the file name (in the upper Excel bar). The tabs corresponding to the selected worksheets are also highlighted with a white background. Any sheet tabs outside the group appear in gray.
Follow these two simple steps to group all worksheets in a workbook:
Ungrouping worksheets in Excel is just as simple:
Alternatively, you can also ungroup selected worksheets in two easy steps:
To ungroup all worksheets, you can also click any worksheet tab outside the group.
Whenever you are working with identical sheets, grouping and editing them all at once can save you a lot of time. Once you have grouped the worksheets, editing the active sheet will make the same changes on all the other sheets.
Here are a few situations when it makes sense to select and work with multiple worksheets at once:
I hope that this article was short and clear and that it showed you, step by step, how to group worksheets in Excel. I publish these Excel tutorials because I truly want you to get better. That is why, if you have additional questions on how to use grouped sheets, please leave a comment, and I'll help you out as soon as possible.
The easiest way to learn Excel is by solving problems, so I have created a dedicated section with useful Excel formulas to help you practice. You can also enhance your Excel knowledge with weekly lessons delivered straight to your inbox. Just fill in the form below, and you'll receive one Excel tutorial every Monday.
Thousands of people have benefited from my free Excel lessons. My only question is, will you be next?