Sort by date

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

unsorted dates

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.

Button to format data as a table

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

Dialog box for converting data range into a table

  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.

      sort either ascending or decending order.

Not sure which sort order is applied?

Just check the direction of the arrow.

Sort Ascending has an upward pointing arrow.

Dates sorted in ascending order from oldest to newest

Sort Descending has a downward pointing arrow.

sorted in decending order with the newest on top

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.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.