Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In this course, Dennis Taylor shares easy-to-use database commands and methods for maintaining an Excel database. The course covers sorting, adding subtotals, auto-filtering, and using the Excel Advanced Filter feature and specialized database functions.
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.
Find answers to the most frequently asked questions about Managing and Analyzing Data in Excel 2010.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.