Skip to main content

How to Create a Sortable Column in an Excel Workbook

Sorting columns and rows is as much a part of Excel as the data used within it. The ability to view data from different perspectives -- whether greatest to least, or alphabetically -- is where Excel shines brightest. It’s not just a tool for collecting data, but viewing it as well. 

And the latter, arguably, is even more important.

How to Create a Sortable Column in an Excel Workbook

And to view that data properly, you need options.

1. Open an Excel workbook or create a new one. 

2. Highlight the column you wish to sort.

3. Click the Filter icon under the Sort & Filter heading. Notice the drop down arrow placed to the right of the column heading.

4. Click the arrow to sort the data how you’d like -- smallest to largest, or vice versa -- and press OK. 

5. Click Sort in the pop-up warning. 

Microsoft Excel Tips