How do I get the word Group off my title bar?

[Jennifer]

Somehow I got the word Group on my title bar in excel, but I do not know how
I did it or how to get rid of it.

[David McRitchie]

Hi Jennifer,
Be very careful what you do with grouped sheets because anything
you do to one sheet will be done to all sheets.

right click on a sheet tab, ungroup sheets.

You might want to save your file as a new file File, save as
and compare what you have with what you had. Because you have
probably seriously damaged your workbook if you made changes.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jennifer" <[email protected]> wrote in message news:[email protected]...
> Somehow I got the word Group on my title bar in excel, but I do not know how
> I did it or how to get rid of it.

[Peo Sjoblom]

Right click a sheet tab and select ungroup sheets, then save the wb
You selected more than one sheet and saved the wb

--
Regards,

Peo Sjoblom

(No private emails please)


"Jennifer" <[email protected]> wrote in message
news:[email protected]...
> Somehow I got the word Group on my title bar in excel, but I do not know
> how
> I did it or how to get rid of it.

[David McRitchie]

Hi Jennifer,
After you have taken steps to avoid further damage by ungrouping.

You might want to read
Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm
specifically
http://www.mvps.org/dmcritchie/excel...d.htm#grouping

And about backing up your data files
http://www.mvps.org/dmcritchie/excel/backup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David McRitchie" <[email protected]> wrote in message news:evj6Hp%[email protected]...
> Hi Jennifer,
> Be very careful what you do with grouped sheets because anything
> you do to one sheet will be done to all sheets.
>
> right click on a sheet tab, ungroup sheets.
>
> You might want to save your file as a new file File, save as
> and compare what you have with what you had. Because you have
> probably seriously damaged your workbook if you made changes.
> --
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Jennifer" <[email protected]> wrote in message news:[email protected]...
> > Somehow I got the word Group on my title bar in excel, but I do not know how
> > I did it or how to get rid of it.
>
>