iWork Numbers, Is it possible to use rows for a variety of titles?

Posted on 2010-01-02
Last Modified: 2012-08-13
I have a very simply database (one page) in iWork Numbers. It contains three separate sections of data, each which I want to be able to sort.

See the attached document. This was originally worked up in Excel. I'm gradually trying to convert to MAC and learning the ropes is a bit complicated. (Note: I had to convert the file to .xls to get it to upload to experts exchange)

Anyway, notice in the file I have various sections, three total. Section 1 has a list of names, up to 26 or so. Section 2 has a list up to 6 names, and section 3 has a list up to 4 names.

Each of these three separate lists need to be sortable separately. But when I to to sort in Numbers, the whole document goes wacked.

So the question is: How can I make it so that only certain lines get sorted? And are there any other suggestions for improving this as far as being a simply database is concerned?
Question by:gregholl
    LVL 1

    Author Comment

    Hi again. OK. I figured out the sorting bit. I had to select "sort rows" in lieu of "Sort entire table" in the little drop down box. Nevertheless, any other suggestions to improve the database would be appreciated.
    LVL 46

    Accepted Solution

    Here are some tutorials:

    LVL 1

    Author Closing Comment

    LVL 46

    Expert Comment

    Glad to help!

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Are you looking to clear some space on your phone for the latest iOS 8 update? Did you switch to Spotify so you no longer need to keep music native on your phone? Run out of space for taking photos while in the middle of vacation? Sometimes the quic…
    In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now