How do I sort my whole spreadsheet based on one row?
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