Want help with Numbers reorganize function

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

  1. gorgewarehouse macrumors newbie

    May 19, 2011
    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

    May 19, 2011
    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.

  3. gorgewarehouse thread starter macrumors newbie

    May 19, 2011
    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

    Aug 1, 2011
    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