Microsoft Excel- How To Sort Data_5572

Microsoft Excel: How To Sort Data

Strategy:

1) Select one cell within your data. The one cell can be in the heading row or any data row. From the menu, select Data – Sort.

2) In the Sort dialog, choose up to three fields to sort by. For each field, choose if the results should be presented in alphabetical order (ascending) or in high-to-low order (descending). If your data is set up correctly as outlined in the List Format topic, Excel will properly guess that your list has a header row, as shown in Fig. 627.

3) Choose OK to cheap sort. Because Customer was the first sort key, all of the records for “ABC Company” will sort to the top. Records for “ABC replacement GMbH” will appear next, as shown in Fig. 628.

Additional Detail: When there is a tie – such as the four records for “ABC shop GMbH” – those records will be sorted in ascending order by the product field. For instance, the ABC product record appears before the cheap DEF product field. If there is still a tie Hp Pavilion Zv5000 Battery, the records remain in their original sequence from before the sort.

Alternate Strategy: If charger your data zxcsky09529 is properly set up in list format Ibm Thinkpad X30 Battery, you can select a single cell in the data and choose the Sort Ascending button in the Standard gateway toolbar Dell Vostro 1720 Battery, as shown in Fig. 629.

This will sort the data by the column in which the cell pointer is currently located. Because Excel resolves new ties by leaving the previous sequence in place Dell Inspiron B130 battery, you can duplicate the sort shown above. First, select a cell in the product field and choose AZ store to sort by product. Next, select a cell in the Customer field and choose AZ to sort by Customer. The data will be sorted by customer, with ties compaq sorted by product.

The ZA button next to Sort Ascending can be used to Sort Descending.

Gotcha: Before trying any sort discount operation, you must either select the entire range or a single cell in that range. If you mistakenly choose two cells in a range, Excel will sort just acer aspire those selected cells, resulting in a few cells of your data being sorted into new records – a disastrous result.

Summary: zxcsky09520 Sorting data is easy using either the Sort menu or the Sort buttons on the Standard toolbar.

Commands Discussed: Data – Sort

Images