Numbers

Discussion in 'iPad for Business and Education' started by Pauley, Apr 5, 2014.

  1. Pauley
    Offline

    Pauley iPF Novice

    Joined:
    Jun 25, 2011
    Messages:
    94
    Thanks Received:
    1
    Trophy Points:
    8
    Location:
    New Hampshire
    Ratings:
    +1 / 0
    Created a database of members in our veterans association. I frequently am adding new names and would like to have Numbers to sort them alphabetically. I am told it can be done, but for the life of me, I just can't figure it out...
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,296
    Thanks Received:
    1,993
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,238 / 1
    Select the table by tapping anywhere on it.

    Once the table is selected you should see segmented bars above and to the left of the table.

    Tap the segment above the column you want to sort by.

    A pop-up menu will appear. One of the options should be Sort. Tap it and you'll get an Ascending/Descending option. Headers and footers are automatically excluded from the sort.

    NumbersSort.png

    http://www.apple.com/support/ios/apps/
    • Like Like x 1
  3. Pauley
    Offline

    Pauley iPF Novice

    Joined:
    Jun 25, 2011
    Messages:
    94
    Thanks Received:
    1
    Trophy Points:
    8
    Location:
    New Hampshire
    Ratings:
    +1 / 0
    That is what I am doing, but there is no sort option. It has everything shown in the photo except the sort....
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,296
    Thanks Received:
    1,993
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,238 / 1
    That's odd. I can't think of any way to intentionally turn off sort.

    What kind of data is in the column?

    Are there any merged cells in the column?

    Do you have only one column selected?

    Is all the data in the column the same type? Including the first and last if they are not set up as a header and footer?

    Can your provide a screen shot of the table so I can see if I can spot any problems?
    {Skitch is a handy app for censoring any sensitive data}
  5. Pauley
    Offline

    Pauley iPF Novice

    Joined:
    Jun 25, 2011
    Messages:
    94
    Thanks Received:
    1
    Trophy Points:
    8
    Location:
    New Hampshire
    Ratings:
    +1 / 0
    The type of data in the column is a Last Name. No cells are merged. Only one column is selected. All data in the column is the same (Last Name) . This is only a partial listing of the entire database. There are more than 300 names in it....

    Attached Files:

  6. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,296
    Thanks Received:
    1,993
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,238 / 1
    There appear to be some merged cells at the far right.

    When sorting the entire table is re-arainged based on the chosen column. The merged column cells to the right would not be able to follow their corresponding cells in the sort column. Yes, they are empty, but I don't think the spreadsheet takes that into account.

    Anyway, that's my guess. Un-merge those cells, and any other column merged cells in the spreadsheet. Merged row cells should be ok.

    Anyway, that's my guess on the matter. It bears out in testing, as I merged some column cells in a spreadsheet that wold sort, and the sort option went away.


    If I'd thought it through more I'd have originally said look for merged cells in any column, not just the sort column. Sorry.
  7. Pauley
    Offline

    Pauley iPF Novice

    Joined:
    Jun 25, 2011
    Messages:
    94
    Thanks Received:
    1
    Trophy Points:
    8
    Location:
    New Hampshire
    Ratings:
    +1 / 0
    That did the trick. I deleted the last (empty) column and all went perfect. Thank you so much for your help.
  8. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,296
    Thanks Received:
    1,993
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,238 / 1
    No problem. Glad to help. :)
  9. Pauley
    Offline

    Pauley iPF Novice

    Joined:
    Jun 25, 2011
    Messages:
    94
    Thanks Received:
    1
    Trophy Points:
    8
    Location:
    New Hampshire
    Ratings:
    +1 / 0
    You have also helped me in the past. You are the supreme guru!
  10. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,296
    Thanks Received:
    1,993
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,238 / 1
    Thanks :eek:
Similar Threads
  1. alkan
    Replies:
    4
    Views:
    3,443
  2. hberninger
    Replies:
    5
    Views:
    873
  3. markskidmore
    Replies:
    4
    Views:
    1,116
  4. rmpresti
    Replies:
    3
    Views:
    499
  5. Richard Webb
    Replies:
    2
    Views:
    872
Loading...

Share This Page