Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
[group]
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
[group]
shereen, you have two or more sheets selected, grouped, right click on a
sheet tab and ungroup sheets -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "shereen" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
[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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn off [Group] mode? | Excel Discussion (Misc queries) | |||
Removing file [Group] designation | Excel Discussion (Misc queries) | |||
Help! [Group] in the caption and I can't use auto filter anymore. | Excel Worksheet Functions | |||
Getting Rid of [GROUP] ?? | Excel Discussion (Misc queries) | |||
[group] in heading | Excel Discussion (Misc queries) |