An Overview of Sort & Filter Group in Excel

We often feel the need to organize data when it becomes prolonged or has a lot of data entries. To keep the data list managed, we can use the Sort & Filter group in Excel. The Sort & Filter group consist of the Sort command and the Filter command. Their functions are different but they both are used to rearrange the data. This article will give you an overview of the Sort & Filter group in Excel.

Features of Sort & Filer Group

The Sort & Filter group consist of the Sort command and the Filter command. Their functions are different but they both are used to rearrange the data.

Sort & Filter Group in Excel

1. Sort Command from Sort & Filter Group

Data can be sorted with the Sort command in ascending or descending order, by column, or by row, and according to certain inputs like number, text, date etc.

Sort any column or row you like, using the Sort window. It will appear by clicking on the Sort command.

Sort Window from Sort & Filter Group in Excel

1.1 Sorting in Ascending Order (A to Z)

You might need to sort alphabetically the entries in a list that you have in an Excel spreadsheet.

Ascending Sorting from Sort & Filter Group in Excel

Use the A to Z command from the Sort & Filter group to place the data in ascending order.

If you want to sort the numbers, the Ascending (A to Z) Sort command will rearrange the numbers from smallest to largest.

1.2 Sorting in Descending Order (Z to A)

Excel allows you to change the sort order from ascending to descending if you need to reverse the sorting order. This way the arrangement will lead from Z to A.

Descending Sorting from Sort & Filter Group in Excel

The Descending (Z to A) Sort command helps you view values with the highest values first when you want to.

2. Filter Command from Sort & Filer Group

Data can be filtered with the Filter command according to inputs like number, text, or date. Click on the Filter command and it will give small arrows on each header.

Remove the checkmarks from the filter section to hide particular rows or columns of data. This way you can display specific data and find it easily from a long data list.

Filter Data using the Sort & Filter Group in Excel

2.1 Advanced Filter

The Advanced Filter command is an amazing option to quickly locate and extract the data you require from a large dataset. It allows you to extract only the data you require and is very helpful when you need to search data depending on multiple criteria.

Advanced Filter in Sort & Filter Group in Excel

2.2 Clear Filter

Clear Filter activates when you have already applied the Filter command in the datasheet. It is used for removing all the filters from the data table

Clear command in Sort & Filter Group in Excel

2.3 Reapply Filter

Your dataset becomes disorganized if you have already filtered your data table but still need to randomly add new entries to it. To overcome this problem use the Reapply Filter command. It will reapply your preferred filtering criteria in the dataset again.

Reapply filter command in Sort & Filter Group in Excel

Sort & Filter Keyboard Shortcut

  • Ascending (A-Z) Order: Select the data where you want to apply Ascending Sort and press ALT + A + S + A consecutively.
  • Descending (Z-A) Order: Select your target data. Press ALT + A + S + D consecutively.
  • Sort: Press ALT+A+S+S.
  • Filter: Press ALT+A+T.
  • Advanced Filter: Press ALT+A+Q.
  • Clear Filter: Press ALT+A+C.
  • Reapply Filter: Press ALT+A+Y.

🔗 65 Shortcut Keys in Excel [Free PDF Download]

Conclusion

One of the niftiest features in Excel is the Sort & Filter commands from the Soft & Filter group. I hope you get an overall idea about the Sort & Filter group. Please visit your Blog page for more helpful Excel-related articles. Thank you!

(Visited 24 times, 1 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *