+ Reply to Thread
Results 1 to 13 of 13

Can't Sort or Filter

  1. #1
    Registered User
    Join Date
    04-25-2007
    Posts
    24

    Can't Sort or Filter

    I have a worksheet of 10 Columns and over 5000 rows.
    The worksheet has the word {Group} in brackets after the file name.
    When I pasted this worksheet into an old file I have been using for a long time it added the word {Group} to this file also.

    I am unable to use sort or filter on this worksheet as they are both grayed out.

    Thanks for any help offered.

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Can't Sort or Filter

    Hi,

    Have you solved your "time minus time" post ...???

  3. #3
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,520

    Re: Can't Sort or Filter

    Quote Originally Posted by JXBlack
    The worksheet has the word {Group} in brackets after the file name.
    It would seem you have 2 or more sheets Grouped together - ie multiple sheets are selected
    (when Grouped actions undertaken on one sheet are replicated on the other sheets selected simultaneously - certain actions like Sorting are however precluded)

    Right click on the Tab name of the visible sheet and select Ungroup, at which point "Group" should disappear from the file name.

  4. #4
    Registered User
    Join Date
    04-25-2007
    Posts
    24

    Re: Can't Sort or Filter

    Ref: JeanRage

    Yes "time minus time" solved thanks to DonkeyOte.

    Ref: DonkeyOte.

    Thanks for "ungroup". This worked as well

  5. #5
    Registered User
    Join Date
    11-13-2004
    Posts
    1

    Re: Can't Sort or Filter

    Thank You DonkeyOte's.

    Gosh sometimes Microsoft makes things harder by trying to make them easier (does that make sense?)

    Anyway, thanks. This little post ended a period of frustration for me.

    Best,

    Joe

  6. #6
    Registered User
    Join Date
    01-09-2012
    Location
    Northumberland, England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Can't Sort or Filter

    Thank you! Would have been at it for several hours more if I hadn't found this!

  7. #7
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Re: Can't Sort or Filter

    Apologies for bringing this post back to life, but i had teh same problem and a quick forum search led me here.

    Great support on this forums!! well done all.

  8. #8
    Registered User
    Join Date
    05-02-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Can't Sort or Filter

    Quote Originally Posted by DonkeyOte View Post
    It would seem you have 2 or more sheets Grouped together - ie multiple sheets are selected
    (when Grouped actions undertaken on one sheet are replicated on the other sheets selected simultaneously - certain actions like Sorting are however precluded)

    Right click on the Tab name of the visible sheet and select Ungroup, at which point "Group" should disappear from the file name.
    It's been several years since you posted this suggestion, but I want you to know that you just helped another very frustrated person with this answer. Thank you!

  9. #9
    Registered User
    Join Date
    06-03-2014
    Posts
    1

    Re: Can't Sort or Filter

    This was helpful to me as well. Just one additional note - the excel file with which I was working was created in SPSS. Apparently SPSS automatically groups the three sheets in the file. Not sure I would have figured that out without this tip - thanks so much.

  10. #10
    Registered User
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007
    Posts
    1

    Re: Can't Sort or Filter

    This tip, to ungroup, solved my frustration of several days. I doubt I would have been able to figure it out myself. Thank you!!!!!!!!

  11. #11
    Registered User
    Join Date
    10-17-2014
    Location
    Tampa Bay, Florida
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Can't Sort or Filter

    This reply worked for my data sort. Thank you very much!!

  12. #12
    Registered User
    Join Date
    10-24-2017
    Location
    Lahore, Pakistan
    MS-Off Ver
    2013
    Posts
    1

    Re: Can't Sort or Filter

    I have imported excel files from our student data base but am unable to use filter, after putting the filter it does not show the data in the filter dialogue box please help..

  13. #13
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,344

    Re: Can't Sort or Filter

    bashir khan welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1