How to do Sorting and Filtering in MS Excel
How to do Sorting and Filtering in MS Excel: Sorting
|When you sort information in a worksheet, you can see data the way you want and find values quickly. You can sort a range or table of data on one or more columns of data; for example, you can sort employees first by department and then by last name.|
Sorting lists is a common spreadsheet task that allows you to easily reorder your data. The most common type of sorting is alphabetical ordering, which you can do in ascending or descending order.
To Sort in Alphabetical Order:
- Select a cell in the column you want to sort (In this example, we choose a cell in column A).
- Click the Sort & Filter command in the Editing group on the Home tab.
- Select Sort A to Z. Now the information in the Category column is organized in alphabetical order
Remember all of the information and data is still here. It’s just in a different order.
Shortcut of sorting: Alt D S
|By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. With filtering, you can control not only what you want to see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on exactly the data that you want to see.|
This allows you to focus on specific spreadsheet entries.
To remove all filters, click the Filter command once again or press the below shortcut
Shortcut of filtering: Ctrl Shift L