From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Sorting data

Sorting data - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Sorting data

“

If you work with large lists, sometimes you want to change the order of the list. This list which has over 700 names, it's on the sorting sheet in the 12 Database Features file; it's organized by Employee Name alphabetically. We might want to rearrange this list based on what we see in the Department column, or possibly the Hire Date column. In fact almost any column in this list could be the basis for sorting. Sorting will proceed much more smoothly if you know for sure that the list you are working with has no empty rows, no empty columns. If I put an empty row in here and I'll do it on purpose here, Right-Click Insert, if I had ignored that or didn't know about it, and I'm going to change the zoom factor here to make it visible. If we were to click in one of the cells here and start the process of sorting by way of the DATA tab and choose Sort, you can see in the background that Excel will only pick up the data down to row 27 and that's certainly not what we would want. So make…

Contents