It is very easy to use Filter in Microsoft Excel. To dot that-
1. Make sure your data has headers on the top row. These headers will be used as the filter criteria.Select the range of cells that you want to apply the filter to. You can click and drag to select multiple columns or rows.
2. In the "Home" tab in the Excel ribbon select "Sort & Filter" group and then click on the "Filter" button. This will add filter drop down arrows next to each header in the selected range. You will notice that drop down arrows appear next to each header cell. You can go to "Filter" button from the "Data" tab of excel ribbon.
3. Click on the drop down arrow in the header cell of the column you want to filter. A drop down menu will appear. From the drop down menu, you can select the specific values, text, or conditions you want to filter by. You can also use search options or sort the data in ascending or descending order.
4. Once you have selected your desired filter criteria, click on the "OK" button. The filter will be applied to the selected range, and only the data that matches the filter criteria will be displayed. Rows that don't meet the criteria will be temporarily hidden.
5. To remove the filter and show all the data again, go back to the "Data" tab and click on the "Filter" button. This will disable the filter and show all the rows.
Comments
Post a Comment