How data in Excel is arranged in a specific conditional order

Excel is arranged in date order

First, select the area you want to arrange sequentially, and then open the menu bar "data"--> sort--> Click Options in the lower-left corner of the sort window, and then enter the sort options, where we can select the type we need to sort, and then make sure.

Tip: Here I am according to the Order of the week, we can choose according to their own needs, such as: By month, arranged by the quarter, the date of the English arrangement and so on.

　　Excel is arranged in alphabetical order

In fact, just described above in chronological order, the letter arrangement is believed that most people already know. Also select the area you want to arrange sequentially, and then click the Data--> sort--> option--> find a,b,c in custom sort order ... J "Determine after selection, OK.

　In Excel in order of numbers from small to large

This is our usual office of the most commonly used in a sequential arrangement, the beginning of the steps we should all know it! Select the cells you want to arrange, the--> sort--> option--> Select the first "normal" in "Custom sort order" and then OK.

Look at the picture below, all the numbers are in the order from small to large!