How to Sort by Date in Excel
To sort data by dates in Microsoft Excel, follow these steps- Let’s check out these steps in detail. Open the spreadsheet with Microsoft Excel on your computer. After that, you should see a column containing all the dates. You need to select all the cells that have a date. In other words, you should not choose the header row. Then, make sure that you are in the Home tab. If so, you can see a button called Sort & Filter. After clicking this button, you should click the Sort Oldest to Newest or Sort Newest to Oldest option.
As the other data of the spreadsheet must be changed according to the date column, Microsoft Excel should show you a warning at this point. You need to ensure that the Expand the selection option is selected. If yes, you can click the Sort button.
Now, your date should be sorted by date.
How to sort data by date in Excel Online
To sort data by date in Excel Online, follow these steps- Read on to know more about these steps. At first, open the spreadsheet with Excel Online and select the whole sheet. In case you do not know the process, you can follow our Microsoft Excel tips and tricks guide to know. Now, make sure that you are in the Home tab. Here you can find an option called Sort & Filter. After clicking this button, you need to select the Custom Sort option.
After that, choose the date column from the Column list, select Cell Values from Sort On list, and choose Sort Ascending or Sort Descending from the Order list. At last, click the OK button.
Your data should be sorted by date. That’s all! Hope it helps.
