How to Group Worksheets in Excel

1. Start Microsoft Excel 2007, and open a workbook that contains multiple worksheets that you would like to group together.
2. 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.
3. Select the first tab of the sheet that you would like to include in the group of worksheets.
4. 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.
5. 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.