Menu
Cart 0

How to sort data in an Excel table

Posted by Roger Hyttinen on

In a previous post, we looked at how to create an Excel table. Once you’ve entered in all your data, you can then reorganize it in alphabetical or numerical order. For example, you may want to sort a list of customers alphabetically by last name or sort the list numerically by sales.

Excel allows you to sort in either ascending (A to Z for alphabetical data, smallest to largest for numbers and oldest to most recent for date) or descending order (Z to A for alphabetical data, largest to smallest for numbers and most recent to oldest for dates).

Sort buttons in Excel

To quickly sort a single column of data in a table, click anywhere in the column that you wish to sort and click the Sort Ascending or Sort Descending button on the Sort & Filter group on the Data Ribbon. Excel will sort all of the data in the selected column, as well as the other columns in your table so that all of your rows are sorted correctly.

To Quickly Sort an Excel Table

  1. Click anywhere in the column that you wish to sort.
  2. Click the Data tab on the Ribbon.
  3. Click the Sort Ascending or Sort Descending icon on the Sort & Filter group on the Data Ribbon.

Our Excel 2016: Up To Speed guide is now available in printable PDF format from this site. The Up To Speed series is designed to help you get productive quickly with your software.  Check back as new titles will be added regularly.

 


Share this post



← Older Post Newer Post →


Leave a comment

Please note, comments must be approved before they are published.