[Group] in Excel top bar, worksheet won't filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was attempting keyboard shortcuts when suddenly [Group] in the filename on
the top bar of Excel.

Now the filter functions are greyed out and I'm stuck.
 
crckrjck said:
I was attempting keyboard shortcuts when suddenly [Group] in the filename
on
the top bar of Excel.

Now the filter functions are greyed out and I'm stuck.
Click to expand...

This means you have multiple worksheet tabs selected. To remove the
group, click on any worksheet tab that isn't white or right-click over one
of the white (grouped) worksheet tabs and choose "Ungroup Sheets" from the
shortcut menu.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* Unsolicited e-mail replies will be ignored *
 
Thanks, the help files leave that out!

Rob Bovey said:
crckrjck said:
I was attempting keyboard shortcuts when suddenly [Group] in the filename
on
the top bar of Excel.

Now the filter functions are greyed out and I'm stuck.
Click to expand...

This means you have multiple worksheet tabs selected. To remove the
group, click on any worksheet tab that isn't white or right-click over one
of the white (grouped) worksheet tabs and choose "Ungroup Sheets" from the
shortcut menu.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* Unsolicited e-mail replies will be ignored *
Click to expand...
 
Back
Top