How to Group Worksheets in Excel

By eHow Computers Editor

Rate: (0 Ratings)

You can group together all or some of the worksheets in a Microsoft Excel 2007 workbook. The advantage of forming worksheet groups is that you can format the worksheets all at the same time. Keep reading to find out how you can use this time-saving feature of grouping worksheets in Excel.

Flag Article

Instructions

Difficulty: Easy

Things You’ll Need:

Microsoft Excel 2007

Step1

Start Microsoft Excel 2007, and open a workbook that contains multiple worksheets that you would like to group together.

Step2

Locate the sheet tabs for the worksheets. They are on the bottom, left side of the Excel screen. You may have named them or they may be named as their default names: “Sheet1,” “Sheet2” and so on.

Step3

Select the first tab of the sheet that you would like to include in the group of worksheets.

Step4

Press down the CTRL key on your keyboard and use your mouse to click on the next sheet that you would like to be include in the group. Continue to do this until all the sheet tabs are highlighted that you want to include in the group. The selected sheet tabs will appear white.

Step5

Release the CTRL key when you are finished selecting the worksheets that are to be included in the group. The worksheets are automatically grouped when you select them. Notice that “(group)” is beside the name of the file that appears in the workbook title bar.

Tips & Warnings

If you want to include all the worksheets in your workbook into one group, then you select the sheet tab of the first worksheet, press down the SHIFT key and then select the sheet tab for the last worksheet. This will select all of the sheet tabs.