How to Sorting and Filtering data in MS Excel?

1. Sorting Data:- 

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. We may want to sort a table to put names in alphabetical order. Or, maybe we want to sort data by Amount from smallest to largest or largest to smallest. Select the Column by which you want to sort data. 

1. Select a cell in the column we want to sort (a column with numbers). 

2. Click the Sort & Filter command in the Editing group on the Home tab. 

3. Select From Smallest to Largest. Now the information is organized from the smallest to largest amount. 

2. Filtering Data:-

 Filtering is a quick and efficient method where we display only that data that meets a given criteria. Ms excel uses two types of filtering methods, that is, Auto filter and Advanced filter. 

1. Select the Data tab, then click the Filter command. A drop-down arrow will appear in the header cell for each column. 

2. Click the drop-down arrow for the column you want to filter. 

3. The Filter menu will appear. 

4. When you're done, click OK. 

5. The worksheet will be filtered according to your search term.