Sort by date

Quickly scanning data by date order can be difficult if your data is in a random order like in this picture.

In Excel Online, the dates you want to sort need to be formatted as a table. Here's how:

1. Select the dates you want to sort and click Format as Table.

1. CheckMy table has headerseven if your date column doesn't have one.

1. Click the column header, and pick a sort order:

   • Click Sort Ascending for oldest date on top.

   • Sort Descending for newest date on top.

     

Not sure which sort order is applied?

Just check the direction of the arrow.

Sort Ascending has an upward pointing arrow.

Sort Descending has a downward pointing arrow.

Tip:  When you add new dates to the table, select the column and reapply the sort order.

For a quick and basic sort, see Sort data in a worksheet.