Benches Uncategorized

5

Does Numbers '09 Have A Way To Filter/Sort Rows...

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Saw a VDO of some one who selected various rows within an Xcell spreadsheet and gave them a specific color. Than was able to get the Xcell spreadsheet to show all the colored rows together at the top of the spreadsheet. Pretty cool.

I can't do that in '08. Can it be done in '09? Trying to to a search on this very time consuming. Thank you for your understanding.

Standing by.

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    NowWhat! wrote:
    I can't do that in '08. Can it be done in '09? Trying to to a search on this very time consuming. Thank you for your understanding.

    Sorting is discussed in Chapter 3, Using tables, or the Numbers '09 User Guide, starting on page 64. Sorting is done on the values contained in the cells to be sorted. Text colour and Fill colour are properties of a cell, but not 'values contained in the cell,' so sorting does not take them into account. You can also sort by Categories. Details in the guide, available for download through the Help menu in Numbers.

    Regards,
    Barry

  2. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hey Barry,
    Thanks for the reply, appreciate it. That's too bad '09 can't do it.

    It's a nifty feature Xcell has. Maybe the next version of Numbers will have it.

    Thanks again. Cheers.

  3. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    NowWhat! wrote:
    It's a nifty feature Xcell has. Maybe the next version of Numbers will have it.

    If you think it would be a useful feature, the best thing to do is to Provide Numbers Feedback, using the item of that name in the Numbers menu the next time you have the application open. Comments sent through that route go directly to Apple and the Numbers developers. Comments posted here go to users like yourself, and are unlikely to produce a change in the next version of Numbers.

    Regards,
    Barry

  4. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Barry,
    Awesome. Will do that. I've just recently started using Numbers and I love it.

    I'll go back and watch how it was done on Xcell and forward the 'wish' to Apple.

    Again, really appreciate your help.

  5. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thanks for the feedback.

    Regards,
    Barry