Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Although not frequently needed, you can sort by rearranging the left or right order of columns, instead of the much more common rearranging of rows from top to bottom. As we look at this worksheet here, I think you could begin to see what we're headed for. We might want to rearrange this data in such a way that our cities are alphabetized from left to right. Now, unlike the shortcuts we have seen with prior examples of sorting, we must highlight all of the data in question here. What we're about to do as I zoom back here is to select this data specifically.
This is what we want to rearrange. We do not want to touch the data in column A at all. We simply want to rearrange the column data as we see it. We want Albuquerque to be on the left- hand side, then Atlanta and so on. We want these alphabetized. So we must specifically highlight all the data and we must use the Sort command on the Data tab. What's different here? The Options allow us to sort in the unusual sort left to right, not top to bottom.
What do we want to sort on, based on what, what are we seeing? It's the data in Row 3. Now, notice there are options now since we made the choice to sort left to right. in the Sort by options we're not going to be seeing field names; we're going to be seeing row numbers. We want to sort based on what we see in Row 3. Of course the big concern right away is thinking of how this might look. Are the numbers below this going to travel with it? Well, yes, they will. Keep an eye on Albuquerque then. Number right below that is all 2, so that's easy to remember.
So as I click OK here, we will be rearranging the data as we see the data in columns B through M. We expect to see Albuquerque over there in column B and all of its data with it, and then Atlanta and probably Boston, and so on. Click OK, there we go! And that rearranged the order of the columns left to right. So as we've seen here the rearranging of the columns here is pretty fast and straightforward. You do have to highlight all of the data, but when the need arises, sorting by rearranging the columns is an easy task.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64772 Viewers
80 Video lessons · 124353 Viewers
52 Video lessons · 60287 Viewers
59 Video lessons · 46113 Viewers