Sort & Filter data with Excel
Sorting of data refers to the arrangements of data that add meaning to the data collected. It may involve rearranging data in a specific order. For example, numerical data collected can be sorted in increasing or decreasing order. Excel offers additional sorting options, including sorting by custom lists. Custom lists are useful when you want a user-defined order that doesn’t follow existing sort rules.
Filters is used to temporarily hide some of the data in a table, so you can focus on the data you want to see. When filtering, you can specify exact matches or comparisons (‘more than’, ‘less than’) or data that doesn’t match specific criteria.