Friday, April 15, 2011

How to Ungroup Worksheets in Excel


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.

Blogger news