How to sort by date in excel

How to sort excel by date: first enter the information, click "Data", then click "Auto Filter"; then sort by "Following Time", click the downward arrow behind the following time, and ascending order will appear descending sort.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to sort excel by date:

1. First, we enter the work plan and time information that need to be recorded into the table

2. Use the mouse to click on the "5" position before the time below to select the table title row and click "Data" , and then click AutoFilter.

3. At this time, you will find that in the "Next Time", "Content", There will be a downward arrow behind the "Start Time", "Complete Time", and "Report Time" columns.

4. If you want to sort by "Next time", click on the next time down arrow and you will find a toolbar. There are two buttons "Ascending" and "Descending" displayed.

5. If you click descending order, the earlier time will be at the bottom. If you click In ascending order, the earlier the time is at the top.

6. You can sort by different options. If you look at the start of the work arrangement The time sequence, or the time of planned completion or the time sequence of work that needs to be reported, can be set by clicking the arrow on the right side of the corresponding column and following method 5.

Related learning recommendations: excel tutorial

The above is the detailed content of How to sort by date in excel. For more information, please follow other related articles on the PHP Chinese website!