How to Ungroup Worksheets in Excel

After you have formatted all the worksheets in a Microsoft Excel 2007 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.

Things You'll Need

• Microsoft Excel 2007

Instructions

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

Tips & Warnings

• If you want to ungroup all the worksheets in an Excel workbook, right-click on top of one of the sheet tabs in the group and select "Ungroup Sheets" from the pop-up menu.

• See existing eHow articles to find out how you can group worksheets together in Microsoft Excel 2007.