Help! [Group] in the caption and I can't use auto filter anymore.

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

Guest

This is not a question, just thought I would post since I had a hard time
figuring this one out. The caption of my workbook had the word [Group] at
the end of the title. As a result, the auto filter which I had configured
for the first worksheet was disabled. The cause of the problem is that there
were two worksheets grouped together as indicated by the word [Group]. The
solution is to simply press Shift + Control + Click each worksheet in the
group until the word [Group] disappears from the caption. Hope this helps
anybody that experiences the same thing.
-Leonard Martin
 
Len

A simple right-click and "Ungroup Sheets" is a few less key-strokes.


Gord Dibben MS Excel MVP
 

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

Back
Top