Sort a Column by Date in Excel 2010

Sometimes the spreadsheets that you create in Microsoft Excel 2010 can be more than simple grids full of data. They can be living, fluid organisms that you adjust and configure on a whim to suit your needs. You will find that the sorting and formula tools within the program can be lifesavers when you want to gather some information from your data. But if you have used either the ascending or descending sort feature in Excel before, then you may have been under the impression that it was only good for sorting by alphabetical or numerical values. Luckily this is not the case, and you can also use these tools to sort a column by date.


Sort by Ascending or Descending Date in Excel 2010


The only thing that you need to consider before you use the ascending or descending tools to sort by date in Excel 2010 is whether you want to expand your selection to move the data in corresponding cells when you sort that column. Once you have determined that, then you can use the Ascending sort tool to display the oldest date at the top of the column, or use the Descending sort tool to display the most recent date at the top of the column.


Step 1: Open the spreadsheet containing the date column that you want to sort.

Step 2: Click the heading at the top of the column to select the entire column.

select date column


Step 3: Click the Data tab at the top of the window.

excel 2010 data tab


Step 4: Click the Sort Oldest to Newest button or Sort Newest to Oldest button in the Sort & Filter section of the ribbon at the top of the window.

sort a column by date in excel 2010


Step 5: Choose whether you want to expand the selection to rearrange all of your data when the date column is sorted, or if you only want to sort the selected column and leave the rest of the data in its’ current location, then click the Sort button.

expand selection or continue with current selection


If you do not like the result of the sorting action, you can always press Ctrl + Z on your keyboard, as that will undo the last action you performed.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides