How to Sort by Date in Excel 2010

Last updated on May 1st, 2023 at 10:29 am

Arbitrarily searching for data in Microsoft Excel 2010 can be very time consuming, especially when the fields that you need to locate are not listed anywhere near each other. Fortunately you can easily sort data in Excel by ascending or descending values to make it easier to locate the data you need. This sorting method is not limited to numbers or test, however. You can take advantage of the ascending or descending sort options for cells that contain dates as well. So, for example, if you had a spreadsheet that listed employees by their last name, you could select a “date of hire” field and choose to sort based on that data instead, allowing you to see who your oldest or newest employees were. So continue reading below to learn how to sort by date in Excel 2010.

 

Sorting by Date in Excel

Note that you will be asked if you want to expand your selection to include all of the data on that row. You probably want to do this so that the rest of the information in the row is sorted along with the date column. So, with that in mind, follow the steps in the tutorial to learn how to sort a column by date in excel 2010.

 

Step 1: Open your spreadsheet in Excel 2010.

 

Step 2: Use your mouse to highlight the cells containing the dates that you want to sort.

highlight the data that you want to sort

 

 

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

click the Data tab

 

 

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

click the sort oldest to newest or the sort newest to oldest button

 

 

Step 5: Click the Expand the selection option, then click Sort to make sure that the related data in the adjoining cells is also moved when your data is sorted.

how to sort by date in excel 2010

 

 

There are a lot of helpful other things that can make your Excel experience easier, including the ability to fit all of your columns on one page when you are printing.

Join Our Free Newsletter

Featured guides and deals

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

Newest Guides