Want help with Numbers reorganize function

Discussion in 'Mac Apps and Mac App Store' started by gorgewarehouse, May 19, 2011.

  1. gorgewarehouse macrumors newbie

    Joined:
    May 19, 2011
    #1
    I have a Numbers 2009 (I think) spreadsheet that is 15 columns wide and 1,040 columns high. I want to filter by criteria based on the content of a certain column, so I click Reorganize in the toolbar. Under "Search rows that match the following", I select the column heading and type in the criteria (for example, Contains > Movie). However, I cannot select the checkmark box next to where it says "Search rows that match the following". The checkmark box is grayed out. Why is this disabled? When I try to add more criteria, the computer just "burps" and quickly flashes the check before quickly taking it away.

    I think it's fairly recent. I'm fairly certain that it worked with the first 900 rows. I couldn't find anything in the Numbers help file about it. I posted this question to answers.yahoo.com but nobody replied. Please help!

    I'm running a PowerPC G5 PowerMac upgraded to 4GB RAM. I'd call myself something of a newbie.

    Thanks to all posters in advance.
     
  2. gorgewarehouse thread starter macrumors newbie

    Joined:
    May 19, 2011
    #2
    Still having trouble

    I still have not figured this out. I still cannot filter columns. I don't like to "bump" messages any more than anyone else likes having them bumped. I hope waiting a week is forgivable. I was just wondering if people simply don't know the answer, or if they have another reason for not replying.

    i guess I'm more insecure than an idiot. However, if you solve this issue, you can call me anything you want!

    Please help! Thank you.

    -Kent
     
  3. gorgewarehouse thread starter macrumors newbie

    Joined:
    May 19, 2011
    #3
    I figured it out

    In case any future readers see this through Google or MacRumors searches, I'm posting my solution. I merged two cells together (G999 and G1000). After I unmerged the cells, I was able to filter as I wanted to. Note to self: no more cell merging.

    Anyway, I thought someone might be interested in seeing this. Have a great day!
     
  4. v-raptor, Aug 1, 2011
    Last edited: Aug 1, 2011

    v-raptor macrumors newbie

    Joined:
    Aug 1, 2011
    #4
    thanks for following up

    just a line to thank you for sharing your solution.
    It was helpful and saved me from looking any further
     

Share This Page