excel 03- sheets stay grouped even when I ungroup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Darndest thing I ever saw...sheets will not ungroup. The header does not
read [Group].

This seemed to start when I grouped all sheets to do a page format for all
sheets; wanted to have 1st few lines repeat on each page when it prints.
Figured out I could not do that and ungrouped to do on each sheet.

Now these 3 sheets seem to be permanently stuck together. Any ideas??
 
How are you trying to ungroup the sheets?

Rightclicking on one of the selected tabs and choosing ungroup sheets?

What happens if you try to add a new worksheet? Does that ungroup the sheets
when the new sheet is inserted (delete that sheet later)?
Darndest thing I ever saw...sheets will not ungroup. The header does not
read [Group].

This seemed to start when I grouped all sheets to do a page format for all
sheets; wanted to have 1st few lines repeat on each page when it prints.
Figured out I could not do that and ungrouped to do on each sheet.

Now these 3 sheets seem to be permanently stuck together. Any ideas??
Click to expand...
 

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

Similar Threads

Group/Ungroup with sheet protected 4
How do I group/ ungroup a series of option buttons? 2
How do i enable "Group" & "Ungroup" in a protected sheet 9
After protecting excel unable to group & ungroup few colums 1
Warning that can be created when more than 1 worksheet is selected 3
Can Vba workout if a selection is part of a group? 0
ungroup impossible using Excel 2003 ... 1
2007 Pvt Group/Ungroup symbols 3

Back
Top