We can do Automatic Sorting in Excel using a very simple method. This tutorial will guide all levels of Excel users on how to do automatic sorting in excel.

Figure 1: Automatic Sorting in excel

Automatic Sorting in Excel

  • We will select the data, copy it and paste it in another Column D.

Figure 2: Data table

  • We will click on Data tab and then we will click on A-Z tab to sort the data manually in ascending order

Figure 3: Highlighted sorted data in ascending order

  • We will click on Z-A tab to sort the data manually in descending order

Figure 4: Highlighted sorted data in descending order

Auto sort with Formula in Excel

  • To auto sort with formula, we can use the formula =LARGE(B4:B14).

Figure 5: Excel auto sort table

  • We will insert the dollar sign so that the selection does not change as we move the formula from Cell B4 to Cell B5

Figure 6: Inserted dollar sign to formula

  • We will insert the first largest number A4 in the formula.

Figure 7: Inserted first largest number to the formula

  • We will then click OK button

Figure 8: Automatic sort first large number to table

  • We will drag the cell down to get the second largest number A5

Figure 9: Inserted second largest number to the formula

  • We will drag down to F14 and then click on the OK button

Figure 10: Inserted excel auto sort table

  • This way we can sort the number without clicking on the Data tab and then A-Z

Figure 11:   Excel Auto Sort Table

How to Auto sort in Excel when Data Changes

  • To auto sort in excel when data changes, the sorting we did using Data tab will not change automatically but the sorting using Formula will change.

Figure 12: Excel auto sort when data changes

  • We will find it much easier to sort with excel using formula than using the data tab.

Figure 1: Automatic Sorting in excel

Automatic Sorting in Excel

  • We will select the data, copy it and paste it in another Column D.

Figure 2: Data table

  • We will click on Data tab and then we will click on A-Z tab to sort the data manually in ascending order

Figure 3: Highlighted sorted data in ascending order

  • We will click on Z-A tab to sort the data manually in descending order

Figure 4: Highlighted sorted data in descending order

Auto sort with Formula in Excel

  • To auto sort with formula, we can use the formula =LARGE(B4:B14).

Figure 5: Excel auto sort table

  • We will insert the dollar sign so that the selection does not change as we move the formula from Cell B4 to Cell B5

Figure 6: Inserted dollar sign to formula

  • We will insert the first largest number A4 in the formula.

Figure 7: Inserted first largest number to the formula

  • We will then click OK button

Figure 8: Automatic sort first large number to table

  • We will drag the cell down to get the second largest number A5

Figure 9: Inserted second largest number to the formula

  • We will drag down to F14 and then click on the OK button

Figure 10: Inserted excel auto sort table

  • This way we can sort the number without clicking on the Data tab and then A-Z

Figure 11:   Excel Auto Sort Table

How to Auto sort in Excel when Data Changes

  • To auto sort in excel when data changes, the sorting we did using Data tab will not change automatically but the sorting using Formula will change.

Figure 12: Excel auto sort when data changes

  • We will find it much easier to sort with excel using formula than using the data tab.