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.