And the latter, arguably, is even more important.

How to Use Microsoft Excel Like a ProMicrosoft 365 reviewThe best laptop deals available today

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

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special How to Create a Sortable Column in an Excel Workbook - 47How to Create a Sortable Column in an Excel Workbook - 18How to Create a Sortable Column in an Excel Workbook - 49How to Create a Sortable Column in an Excel Workbook - 86How to Create a Sortable Column in an Excel Workbook - 89How to Create a Sortable Column in an Excel Workbook - 46