Sorting the Data

One of the easiest ways to organize or evaluate your data is to use Excel’s Sort feature. There are a couple of ways to control the sort—you can do a simple ascending or descending sort, or you can specify which data you want to sort and the type of sort you want to conduct.

Conduct an Alphabetic or a Numeric Sort

  1. Select the columns or the portions of columns whose contents you want to sort.

  2. On the Data tab, click the Sort button to display the Sort dialog box.

  3. Specify whether or not the columns have header labels.

  4. Specify which column you want to sort by.

  5. Select Values if it isn’t already selected.

  6. Specify whether the data will be sorted A to Z, Z to A, or based on a custom list (alphabetic); or from smallest to largest, largest to smallest, or based on a custom list (numeric).

  7. If you want to refine the sort by also sorting by a second column, click the Add Level button, and enter the search parameters. Repeat for any further level of search. You can use up to 64 levels in your search.

  8. Click the Options button if you want to change to a case-sensitive sort for text or if you want to sort by rows instead of by columns.

  9. Click OK to sort the data.

    Conduct an Alphabetic or a Numeric Sort
    Conduct an Alphabetic or a Numeric Sort

Tip

Tip

To do a quick alphabetic sort without setting any sort parameters, click the Sort A To Z or the Sort Z To A button on the Data tab; or, if you’ve selected numbers, click the Sort Smallest To Largest or the Sort Largest To Smallest button at the left of the Sort button.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset