Ungrouping

[Brad H]

I have a spreadsheet that is grouped, and I want to ungroup it. I have
selected the spreadsheet and tried using the Draw toolbar, but the Ungroup
option is not highlighted for me to use.

 

[Jim Thomlinson]

From the XL menu select Data -> Group and Outline -> Ungroup

 

[Brad H]

Ungroup is not highlighted to click on.

From the XL menu select Data -> Group and Outline -> Ungroup

 

[Andy Pope]

Hi,

If the sheets are grouped the right click sheet tab and pick ungroup.

Cheers
Andy

 

[Bob I]

If the Worksheet is labeled [Group], R-click the sheet tab and select
"Ungroup Sheets"