Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! [Group] in the caption and I can't use auto filter anymore.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! [Group] in the caption and I can't use auto filter anymore.
Len
A simple right-click and "Ungroup Sheets" is a few less key-strokes. Gord Dibben MS Excel MVP On Thu, 27 Apr 2006 12:16:02 -0700, Len Martin wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|