How to Create a Sortable Column in an Excel Workbook

News
By last updated

Creating a sortable column in an Excel Workbook is easy

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

Bryan Clark

Bryan covers everything you need to know about Windows, social media, and the internet at large for Laptop Mag. Thanks to his extensive knowledge of operating systems and some of the most popular software out there, Bryan has written hundreds of helpful guides, including tips related to Windows 11 drivers, upgrading to a newer version of the OS, editing in Microsoft Photos, or rearranging pages in Google Docs.