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

J

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.
 
D

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.
--
 
P

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)
 
D

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/fillhand.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 said:
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 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top