![sorted3 mac os beta sorted3 mac os beta](https://wallpapershome.ru/images/wallpapers/macos-big-sur-2560x1440-22654.jpg)
You can see here inside of Arizona everything is in alphabetical order.You can quickly change that to sort by, say, population. So it is going to sort first by state ascending and then by city ascending. Then add another column and sort by City. So instead of sorting by anything we will just delete these, clear these out, Sort the Entire Table, Add a Column, and sort by State. We can then control exactly the sorting order.
![sorted3 mac os beta sorted3 mac os beta](https://wallpapershome.com/images/wallpapers/macos-big-sur-1920x1080-iridescence-apple-october-2020-event-5k-23123.jpg)
But it would be nice to have these sorted alphabetically inside of the state.So in order to do that what we can do instead of just sorting with one column is go to Sort & Filter Options which brings up these controls here on the right. Actually they are sorted by population because that is what we had previously. The thing is though, inside of this we see that the cities are not sorted by anything in particular. So we can select Sort Ascending by state and you can see it starts with Alaska, Arizona, etc. The most dense would be New York City.Let's go back to the original table. Now I can simply sort and I get the population density which you can imagine Anchorage is the least dense there. Now I want to paste that quickly into everything here so I'm going to select Command C for copy, select the entire column but I'm going to Command and click and deselect the header here and just paste it into all of the rest of the cells.Now I've got population density for each city. The way to calculate density I'm going to type = and then do population divided by area gives me the population density of Anchorage.
![sorted3 mac os beta sorted3 mac os beta](https://www.iclarified.com/images/news/58010/275840/275840-640.jpg)
So first let's calculate the population density.I'm going to drag this over here to create an extra column and call this density. Say I wanted to sort by population density. If I wanted to resort everything by area I can see what the largest city by area is.Let's make things more interesting. These are the one hundred largest cities in America so it makes more sense to actually sort the other way, descending, so I can see the largest city, next largest city, etc going down.Now I can do the same thing by area. I'm going to sort by ascending which gives me a population starting with the smallest going to the largest. I'm going to do it by column C which is population. When I click on them I get some commands. The way to do that is first let's select a cell inside of a table. But what would be more useful is if we sorted by population. It's just alphabetical and it is great if you want to be able to look up some information. Everything here from the initial list is sorted by city. These are US cities with the State, population, and area. Today let's take a look at Sorting in Numbers.I've imported some data into a Numbers spreadsheet. Check out Sorting In Numbers at YouTube for closed captioning and more options.