Thread: [group]
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default [group]

First...........note which sheets are grouped by checking which have white
colored sheet tabs.

Right-click and "ungroup sheets" or just select any sheet but the active sheet.

The reason I stated "note which sheets" is that while sheets are grouped,
whatever you do to one is done to all in the group.

If you have been in group mode for a while, you could have some interesting
editing to do.


Gord Dibben MS Excel MVP

On Wed, 13 Sep 2006 15:01:02 -0700, shereen
wrote:

I saved a file in Excel, but at the top after the file name it now displays
[Group]. I can no longer auto filter my data. How do I remove this [Group]?
Thanks!