Excel 2007 workbook has [Group] in the title bar

Excel 2007 title bar with [Group] in it

… and everything on the Data ribbon is disabled

Excel 2007 data ribbon disabled

… and all sorting and filtering is greyed out

Sort & Filter ribbon command is greyed out

This is because you have two or more worksheets ‘grouped’. A worksheet can be grouped by holding CTRL and selecting an adjacent worksheet.

To ungroup the worksheets, right-click the worksheet tab at the bottom of excel and choose ‘Ungroup sheets’

Ungroup sheets on the worksheet tabs context menu

(Thanks to Office Online for the pointer)

This entry was written by Grant Holliday, posted on June 18, 2007 at 4:08 am, filed under Resources. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

22 Comments

  1. msw70
    Posted September 13, 2007 at 2:57 am | Permalink

    Thanks for a great entry! You saved me from a very frustrating situation…

  2. JoSHall
    Posted September 19, 2007 at 1:58 pm | Permalink

    Fantastic, only to the point solution I found to this problem!

  3. Alex
    Posted October 12, 2007 at 11:34 am | Permalink

    Thanks!!!

  4. Andy
    Posted October 13, 2007 at 2:27 am | Permalink

    Hey Thanks, the boss was pretty frustrated and that saved her alot of extra time on this project

  5. Jerome
    Posted November 10, 2007 at 3:56 am | Permalink

    That is the exact solution to the issue. Thanks!

  6. Kevin K
    Posted February 2, 2008 at 6:40 am | Permalink

    Thanks so much for this!

  7. Dee
    Posted February 24, 2008 at 11:41 am | Permalink

    Gotta love Google. My number 1 result for my search was this beautifully explained solution. This problem was making me crazy. Much thanks for the clear explanation.

  8. datarat
    Posted April 18, 2008 at 9:11 am | Permalink

    miracle worker. many thanks

  9. Sav
    Posted May 2, 2008 at 8:16 am | Permalink

    Dude! this is awesome!
    Thanks for figuring this out!!!

  10. Rob
    Posted June 18, 2008 at 12:00 am | Permalink

    Thank you very much – what is ‘grouping’ sheets anyway????

  11. DP
    Posted July 18, 2008 at 9:41 am | Permalink

    thanks for this tip
    just been through 15 mins of hell trying to find the answer!

  12. Sumit
    Posted September 14, 2008 at 3:44 pm | Permalink

    This was wonderful resolution, and helped me save my 2 days of work!!!

  13. Amit
    Posted October 10, 2008 at 11:05 pm | Permalink

    Hi,

    First of all, thank you for your help as you show us by example which solve all the doubts and help us in understanding.

    I surf lot of sites but finally i got the appropriate answer here.

  14. Lincoln
    Posted October 17, 2008 at 11:27 am | Permalink

    Thanks God!!!

  15. PellaCAD
    Posted October 24, 2008 at 2:43 pm | Permalink

    Saved me hindquarters…I was goin’ a bit daft…

  16. Bruno
    Posted October 29, 2008 at 10:03 am | Permalink

    Very objective and useful! Many thanks!

  17. Steph
    Posted December 30, 2008 at 9:46 am | Permalink

    Thanks for the explanation!

  18. moek
    Posted March 20, 2009 at 1:13 pm | Permalink

    Thank you so much, really saved me

  19. jazzy
    Posted April 4, 2009 at 5:15 pm | Permalink

    Thanks a lot…really helpful. I was pulling my hairs…No help from Microsoft on this…You people Rock!!!

  20. Ron
    Posted May 31, 2009 at 1:18 pm | Permalink

    Your very clear description of exact issue made this a quick find in Google. Thanks.

  21. Delusion
    Posted June 11, 2009 at 1:41 pm | Permalink

    Thank you. After reading so many useless, ill-informed non-answers elsewhere on the web, finally I found yours and everything’s working correctly again. I’m not sure how I managed to group sheets. I may have fumbled a command.

  22. jaxcaizaer
    Posted June 23, 2009 at 2:11 am | Permalink

    thnk u very much…
    great information


Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*