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

Brad H wrote:

Ungroup is not highlighted to click on.

"Jim Thomlinson" wrote:


From the XL menu select Data - Group and Outline - Ungroup
--
HTH...

Jim Thomlinson


"Brad H" wrote:


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.