Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

Doing Quick Sorts

The Quick Sort buttons offer one-click access to sorting cell values.

Quick Sort a Single Column

There are several quick methods you can choose from to apply simple sorts to your data.

  1. Select one cell in the column to sort by. If you select multiple cells, Excel will sort only the data in the selected range.
  2. On the Data tab, select AZ to sort lowest to highest or ZA to sort highest to lowest.

Quick Sort Multiple Columns

If you keep in mind that Excel keeps previously sorted columns sorted as new columns are sorted, you can use the Quick Sort feature to sort multiple columns. For example, if the Profit column is organized, Excel doesn’t randomize the data in that column when the Customer column is sorted. Instead, Profit retains its order to the degree it falls within the Customer sort. The trick is to apply the sorts in reverse to how they would be set up in the Sort dialog box.

In the following example, we want to sort by Customer and Profit, both least to greatest.

  1. Select a cell in the column that should be sorted last in the Sort dialog box (in this case, the Profit column).
  2. On the Data tab, click the A to Z button.

  3. Select a cell in the next column to be sorted (in this case, the Customer column).
  4. On the Data tab, click the A to Z button.

    10fig13.jpg
  5. The table is now sorted by Customer and then Profit within each customer’s records.

  • + Share This
  • 🔖 Save To Your Account