[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! |
[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! |
[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! |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com