Traditional Culture Encyclopedia - Traditional festivals - excel how to sort by time series

excel how to sort by time series

1, select the need for sequential order of the region;

2, in turn, open the menu bar "Data" ?ú "Sort", then we will see a pop-up "Sorting "dialog box;

3, select the" Custom Sequence "which we can choose the type of sorting we need, and then determine that

can be.

4, select the type of sorting according to the month

5, according to the month of sorting

Note: The above operation is in accordance with the order of the month to arrange, you can also choose according to their own needs, such as: by the week, by the quarter, by the date of the English and so on.