How to Sort Date Column from Newest to Oldest

Please follow the steps below to sort a column with dates from newest to oldest, or check sorting from oldest to newest.

Step 1: Click any cell in the column you want to sort;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Sort&Filter" in the "Editing" section, and click "Sort Newest to Oldest" from the drop-down list;

Step 4: The date column and all other columns are now from Newest to Oldest.

Alternatively, please use right-click as below:

Step 1: Right-click the date column and select "Sort" from the list;

Step 2: Select "Sort Newest to Oldest".

Leave a Reply