Skip navigation

How do I sort my whole spreadsheet based on one row?

634 Views 9 Replies Latest reply: Jun 30, 2012 7:38 AM by dorlow RSS
dorlow Calculating status...
Currently Being Moderated
Jun 21, 2012 11:13 AM

I'm using Numbers on my iPad to inventory a school's computer systems.  I'm kind of doing it slowly as I get time, so I'm not inventorying in any particular order.  I just go in a room when I get a chance and then inventory everything in it. 

 

I have different columns for room, asset #, make, model, serial, inventory date

 

Just a few minutes ago, I was trying to sort my sheet by the asset # so I could see what gaps I have in the asset numbers.  I selected the top bar and it highlights the whole column.  Then I select sort and it only sorts the one column, which then totally screws up my sheet because my asset numbers are next to different random PCs that I just happened to inventory first.  So, of course, I undo it.  But I would like to be able to sort by asset # and have it sort all the cells based on the asset #, or sort by make or model and then I could see all the computers with a certain make or model and where they're at.  There has to be a way to do this.

iPad 2 Wi-Fi, iOS 5.1.1
  • Jerrold Green1 Level 7 Level 7 (28,270 points)
    Currently Being Moderated
    Jun 21, 2012 11:46 AM (in response to dorlow)

    dorlow,

     

    The only explanation I can think of for your situation is that your columns are separate tables, a multiplicity of 1-column tables. Could this be possible in your case?

     

    To test for this possibility, click on a Row Label and see if the entire row is selected, or if only the first cell is selected. If the entire row is selected, it's all one table and if only 1 cell is selected, it's a collection of tables and needs to be reorganized into one integrated table.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,270 points)
    Currently Being Moderated
    Jun 21, 2012 4:05 PM (in response to dorlow)

    Perhaps someone here in the iOS discussion area (now that your post has been moved) will have an idea for you.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,270 points)
    Currently Being Moderated
    Jun 26, 2012 1:12 PM (in response to dorlow)

    dorlow,

     

    I can't believe it either. Please don't be offended, but is it possible you are confusing row and column orientation? It's the only other explanation I can come up with, since you confirmed a single table. Could you post a screen shot of your table with the column you wish to sort on highlighted?

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,270 points)
    Currently Being Moderated
    Jun 26, 2012 2:14 PM (in response to dorlow)

    Found this on the WikiHow site - To make a screen shot::

     

    Simultaneously press the on / off switch and the center home button. You will notice an on-screen flash. If you have sound enabled, you will hear a camera click.

     

    The screenshot will then appear in default photo application.

     

    Jerry

  • KEANDAU Level 1 Level 1 (20 points)
    Currently Being Moderated
    Jun 29, 2012 5:35 PM (in response to dorlow)

    Unfortunately, you will not be able to do exactly what you want.  According to the manual, it only works if you want to sort the first column, then all the data in the rest of the sheet will sort with it. 

     

    So if your Room #'s are in the first Header column (this should be a darker color), and the information related to the rooms is entered along the rows (horizontally), then you tap the top of the first column, the pop-up appears, over-arrow to "Sort", choose Ascending/ Descending. It will sort the first column and the rest of the data in the table will sort with the column, or at least it should! 

     

    You cannot, however, choose the "Model Year" column (not the first) and sort with that.

     

    Here is a work around:  'Insert' another first column, 'Cut' the column with data you wish to sort with, and 'Paste' into your 'new' first column.  Then sort.  I tried this method on my iPhone and it worked for me.

     

    Kevin

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.