Filename displayed followed by [Group]

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

When I open my spreadsheet the name of the file is displayed at the top
followed by [Group]. Example:

Microsoft Excel - Filename [Group]

When this happens I cannot filter and many of the data functions are not
available. is there a way to turn this off?
 
The [Group] indicator means that you have more that one worksheet
selected. When you're in Group mode, any change you make to one
grouped sheet is applied to all grouped sheets (which can be a
blessing if you intended it, or a disaster if you didn't).

The tabs of the grouped sheets all appear in white. To ungroup the
sheets, right-click on the tab of one of the grouped sheets and choose
"Ungroup".

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 

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

My Excel 2007 filename is followed by [Group]. Why? 1
Filter Groups 1
Anyone know what "[VSync]" appended to filename title means? 1
How can I return to the row I left off on after filtering? 1
[group] in heading 2
Can't update my workbook - Name bar shows as "[Group]" 2
Filtered Sort freezing up 1
How do i display the Filename without the path? 3

Back
Top