How to Create a Sortable Column in an Excel Workbook

  • MORE

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.

hero_sortAnd to view that data properly, you need options.

  1. Open an Excel workbook or create a new one. 
    new_sort
  2. Highlight the column you wish to sort.
    highlight
  3. Click the Filter icon under the Sort & Filter heading. Notice the drop down arrow placed to the right of the column heading.
    filter
  4. Click the arrow to sort the data how you’d like -- smallest to largest, or vice versa -- and press OK. sort
  5. Click Sort in the pop-up warning. 
    finish

Add a comment