How to Sort Worksheet Data Using Excel for Mac


show more Sorting worksheet data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Sorting worksheet data

When you enter data into a worksheet, you usually enter it in the order it was received. For example, if you track customer orders, you would enter the first order, the second, and the third, and so on. If you'd like to rearrange the data in the list, such as by the time you got the order or the amount of the order, you can do so by sorting your data. In this case, I have a list of monthly revenues. The data that I've collected are the year, the month, and the revenue value. Let's suppose that I want to sort this list by its revenue, with the highest revenue at the top and the lowest revenue at the bottom of the list.

To do that, I click any cell in the Revenue column, and then on the toolbar, I go up to the Sort button, click the down arrow, and then I can either click Ascending, Descending, or one of these other options. In this case, I want to have the highest values on top and the lowest values on the bottom, so I will click Descending. Now that I've done that, Excel h...

Sorting worksheet data
Video duration: 3m 2s 6h 32m Beginner

Viewers:

Sorting worksheet data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...