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.