How to quick sort using one column in Excel

Abstract

Excel provides a lot of great tools for working with data.

One of those tools is Sort.

In this lesson we’ll look at how to quickly sort a list or table using a single column.

Let’s take a look.

We’ll look at custom sorting in an upcoming lesson.

The descending quick sort button works just the opposite.

Just click anywhere in a column you’d like to sort, and click a quick sort button.

Excel is very good about detecting column headings and will ignore them when sorting.

We can sort letters, numbers, and mixed content in ascending order.

Then, sort them in descending order using the descending quick sort button.

Here, you’ll find the same three options that are on the Data menu.