Easy Way to Group and Ungroup Worksheets in Excel

When you work with files that consist of several sheets and forget to ungroup the sheets whereas the data which must be filled is different, there will be some sheets which are filled by the improperly data. So you need to ungroup the sheets first and then you can fill in the sheets by data that you want.
 

How to Group Worksheets in Excel

You can group together all or some of the worksheets in a Microsoft Excel 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.

Instructions

1. Start Microsoft Excel, 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. 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.

How to Ungroup Worksheets in Excel

After you have formatted all the worksheets in a Microsoft Excel group, you may want to ungroup some or all of the worksheets. This is an easy process that requires you to ungroup the worksheets by using the sheet tabs to indicate which worksheets you want to separate from the group. Find out how you can ungroup your grouped Excel worksheets by reading the steps below.

1. Start Microsoft Excel and open a workbook from your files that contains worksheets that are grouped together.
2. Locate the worksheet tabs at the bottom left of the opened workbook. The sheet tabs that are white are the ones that are grouped together.
3. Hold down the CTRL key on your keyboard and click on the sheet tab of the worksheet that you want to ungroup from the rest of the worksheet group. Once you do this, the worksheet will be turn back to its set color and become separated from the existing group.
4. Release the CTRL key on your keyboard after you have ungrouped the worksheet.
5. Continue to hold down the CTRL key and click to select sheet tabs of the worksheets you no longer want to be included in the group. 

To ungroup all sheet you can also right-click the sheet and then Ungroup Sheet.