Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
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.
- Select one cell in the column to sort by. If you select multiple cells, Excel will sort only the data in the selected range.
On the Data tab, select AZ to sort lowest to highest or ZA to sort highest to lowest.
)
>>>Go Further: Other Quick Sort Options
There are other ways you can access the quick sort options:
Right-click the cell and select Sort, Sort A to Z or Sort Z to A if your data is text; select Sort Smallest to Largest or Sort Largest to Smallest if the data is numerical.
)
From a filter drop-down, select Sort A to Z or Sort Z to A if your data is text; select Sort Smallest to Largest or Sort Largest to Smallest if the data is numerical.
)
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.
- Select a cell in the column that should be sorted last in the Sort dialog box (in this case, the Profit column).
On the Data tab, click the A to Z button.
- Select a cell in the next column to be sorted (in this case, the Customer column).
On the Data tab, click the A to Z button.
The table is now sorted by Customer and then Profit within each customer’s records.
)
)