Sorting columns

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.…