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 quot;Ungroup Sheetsquot; is a few less key-strokes.Gord Dibben MS Excel MVP
On Thu, 27 Apr 2006 12:16:02 -0700, Len Martin
gt; wrote:
gt;This is not a question, just thought I would post since I had a hard time
gt;figuring this one out. The caption of my workbook had the word [Group] at
gt;the end of the title. As a result, the auto filter which I had configured
gt;for the first worksheet was disabled. The cause of the problem is that there
gt;were two worksheets grouped together as indicated by the word [Group]. The
gt;solution is to simply press Shift Control Click each worksheet in the
gt;group until the word [Group] disappears from the caption. Hope this helps
gt;anybody that experiences the same thing.
gt;-Leonard Martin
- Jul 25 Fri 2008 20:45
Help! [Group] in the caption and I can't use auto filter anymore.
close
全站熱搜
留言列表
發表留言
留言列表

