Home >Common Problem >How to sort by date in Excel

How to sort by date in Excel

卡哇伊
卡哇伊Original
2020-07-14 13:34:208859browse

How to sort by date in Excel: First, we enter the work plan and time information that needs to be recorded into the table, use the mouse to click on the "5" position before the time below to select the table title row, and click "Data" Click "AutoFilter" again; then you will find a toolbar. There are two buttons "Ascending" and "Descending" displayed; finally select according to your needs.

How to sort by date in Excel

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

How to sort by date in Excel

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

How to sort by date in Excel

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

How to sort by date in Excel

4. If you want to sort by "subject time", click the downward arrow behind the subtitle time, then you will find a toolbar. There are two buttons "Ascending" and "Descending" displayed.

How to sort by date in Excel

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

How to sort by date in Excel

6. You can sort by different options. If you look at the time sequence when the work arrangement starts, or the time when the plan is completed, or the time sequence when the work needs to be reported, you can Click the arrow on the right side of the corresponding column to set it according to method 5.

How to sort by date in Excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn