Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have an Excel document that's displaying very bizarre behavior-- I'm unable to hide and show grouped rows in a particular document. All the group commands are greyed out, even when I've selected a new set of rows.

Even stranger, the name of the file has [Group] added to it in the title of the window!, whereas the actual file does NOT have that in its name.

I've never seen such oddities before. I tried saving the file under a different name, but the same stuff persists.

Any ideas?

OK, as usual with these things, I did some more Google rummaging and finally hit upon the right search term!

It turns out that it happens when worksheets are grouped.

Here's where an explanation lies
"http://answers.yahoo.com/question/index?qid=20080131083824AAd528z"

One simply right-clicks a worksheet and select ungroup!

It's odd because I never grouped the worksheets--in fact, I don't even know when "grouping" worksheets means!

Oh, well, hope that my posting helps someone else down the road.

Glad you found the solution! "Grouping" is simply a term used to describe
the state the workbook is in when you select more than one sheet. You can do
so by using either the Shift or Command key to select multiple sheets...

The shift key enable selecting multiple consecutive sheets whereas the
Command key enables selecting non-consecutive sheets.

There are any number of reasons why one would do this intentionally, such as
selecting a range of sheets to be printed, "drilling" entries into the same
respective cells on multiple sheets at once, to Move/Copy multiple sheets,
etc. However, it's also easy to do by accident :-)

The reason you were having a problem is that certain commands can't be
executed while multiple sheets are selected... They have to be "ungrouped".

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 2/9/10 8:06 AM, in article 59bb283e.0,
"AstroGuy" <AstroGuy> wrote:
[..]