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.