Sorting from the toolbar


show more Sorting from the toolbar provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Sorting from the toolbar

As you become more comfortable with sorting, there are many times when you want to sort your data quickly and easily. And if your data is all together here, no empty rows within this data, if you'd like to rearrange the entire list by Employee Name, click on a single cell in column A. It can be cell A1 or any of the others. Do not click the column letter itself. Unfortunately, it's pretty difficult to rearrange only the data in column A. That was a major shortcoming of some older versions of Excel. So, click on a single cell. Imagine that we would like to rearrange this entire list, some 740 names, alphabetically by name.

Go to the Data tab. We probably want this alphabetical. There's an AZ button. Click it, the deed is done. And furthermore what if after printing this or reviewing it or sending it onto others, we now change our minds because we want to see the list in alphabetical order by department? We'll click in column C, click the AZ button, and recognize that the orde...

Sorting from the toolbar
Video duration: 4m 2s 1h 32m Appropriate for all

Viewers:

Sorting from the toolbar provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...