How to Group Worksheets in Excel 2007

In this Excel 2007 tutorial, learn how to group together your worksheets in order to make changes to one worksheet that will also be applied to the other worksheets in the group.

Grouping worksheets in Excel will allow you to make format in changes to one worksheet that will also affect to the other worksheet. So if you’d like to group two or more worksheets together then simply go down to your sheet tabs, and select your sheet tabs by clicking on the first you want to be included. Clicking shift on your keyboard and then click an adjacent one or if it’s not adjacent, simply using control to click a non-adjacent one. And once you have two groups together and they will automatically be group together, if you look at your title group, it will say, “group and brackets” meaning that their grouped together. At this point, you can go ahead and make any type of changes to your worksheet and it’s going to also make those changes to your other worksheet. When you're ready to ungroup this, just click on one of the tabs that is grouped, right click and click ungrouped sheets, and it will ungroup the sheets. You can see at the top on the title bar, that’s a workgroup isn’t there anymore.