From the course: Excel 2010 Essential Training

Unlock the full course today

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

Basic and multi-field sorting

Basic and multi-field sorting - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

Basic and multi-field sorting

Another great database type feature that Excel has is the ability to sort data. Now sorting could be a matter of just one or two clicks or you could make it a little more interactive if you need. You can filter your data as you are sorting as well, which is pretty cool. Now if you aren't unfamiliar with database technology, Excel regards each row as like a record in a database and each column is like a field. So we have a Last Name field, First Name field, and so on. So let's say we want to sort by Department. Click anywhere in the Department column. Now do not select the whole column and you don't have to select the whole area. Just clicking anywhere in the Department column is okay. Now, we want to be on the Home tab and over here on the right click Sort & Filter, and just choose Sort A to Z and boom, it's done. Let's say we want to sort by State. Click anywhere in the State column, click Sort & Filter, and maybe let's sort from Z to A. And now we have Vermont at the top and…

Contents