How to Group Worksheets in Excel 2007

Description

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.

Transcript
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.
Related Articles

How to Group Worksheets in Excel 2007

Training Center - Microsoft Excel 2007 Course

The Microsoft Windows operating system and the Microsoft Office suite of productivity software are considered as Microsoft Corporation\'s two most profitable products. As of the third quarter of the year 2009, Microsoft Corporation was ranked as the third largest company in the world, and one of the largest technological corporations in the world. So how about taking a Microsoft Excel 2007 course?...

Microsoft Access 2007 Training

Access 2007 was the mainly complex version of the world\'s mainly trendy desktop database method. It saw fundamental border changes....

Algebra Worksheets

There is a very famous saying that practice makes a man perfect. More the person tries more are the chances of success. It has been proven true in all walks of life....

Advantages of Using VBA in Excel 2007

VBA, or Visual Basic for Applications, is the simple programming language that can be used within Excel 2007 (and earlier versions, though there are a few changes that have been implemented with the Office 2007 release) to develop macros and complex programs. The advantages of which are: the ability to do what you normally do in Excel, but a thousand times faster....

Goal Setting Worksheet

You can build your own goal setting worksheet or template for free, simply by answering these 12 questions. Create one of these goal setting worksheets for each of your major goals, answer the questions, and experience the satisfaction of moving towards your dreams....

Tidbits of Help - Excel 2007 - Formulas to Calculate Values

As I've mentioned before, Math and I (generally) aren't on speaking terms. Well, OK the higher end algebra type - yikes! So, anytime I can find a way for something else to do the math for me, I'll take it!...

The Benefits of Anger Management Worksheets

Are you getting trouble with stressful problems, people or events? Anger management worksheets can be useful tools to help you face to this situation. The expression of negative emotions can have lasting impacts on your career, your family or close friends. These helpful guides done on your time may help you cope in case access is an obstacle to anger management counseling or resources. You c...

Freeze Panes in Excel 2007

Microsoft Excel 2007's workbooks is designed with a massive benefit for users such as creating exhaustive worksheets without fear of inadequate memory. But the loss of crucial information in vision will happen when you have made use of the vast amount of cells and columns Excel 2007 has to offer, the column and row headings that you created at the outset will be so long past. And you should remark...

Significant differences between Office 2007

I’ve read a lot of early documents trying to sort out and describe the new Office 2007 interface...

Alphabet Worksheets for Preschool Reading Lessons

Alphabet worksheets are perfect for preschool studying lessons, specifically when it comes to phonics...