How to Sort Columns of a Data List in Excel 2013
How to Use Ready-Made Number Filters in Excel 2013
How to Use Custom Filters in Excel 2013

How to Sort on Multiple Fields in Excel 2013

Step 1 of 4
Previous
Next Slideshow
Next Slideshow

Position the cell cursor in one of the cells in the data list table. Click the Sort button in the Sort & Filter group on the Data tab or press Alt+ASS.

Excel selects all the records of the database (without including the first row of field names) and opens the Sort dialog box. Note that you can also open the Sort dialog box by selecting the Custom Sort option on the Sort & Filter drop-down button’s menu or by pressing Alt+HSU.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
How to Filter with the Excel 2013 Top Ten Option
How to Use Advanced Filtering in Excel 2013
How to Subtotal Data in Excel 2013
The Excel 2013 AutoFilter Feature
Sort Excel 2013's Data Lists on Font and Fill Colors and Cell Icons