What do you mean by custom filtering? Write the steps of applying it.
Answers
Answered by
3
Filter data by specifying conditions
By specifying conditions, you can create custom filters that narrow down the data in the exact way that you want. You do this by building a filter. If you've ever queried data in a database, this will look familiar to you. Point to either Number Filters or Text Filters in the list.
To sort in a custom order, follow these steps:
1.Select one cell in the column you want to sort.
2.Press Ctrl + A, to select the entire region.
3.Check the selected area, to make sure that all the data is included.
4.On the Excel Ribbon, click the Home tab.
5.In the Editing group, click the arrow on Sort & Filter.
By specifying conditions, you can create custom filters that narrow down the data in the exact way that you want. You do this by building a filter. If you've ever queried data in a database, this will look familiar to you. Point to either Number Filters or Text Filters in the list.
To sort in a custom order, follow these steps:
1.Select one cell in the column you want to sort.
2.Press Ctrl + A, to select the entire region.
3.Check the selected area, to make sure that all the data is included.
4.On the Excel Ribbon, click the Home tab.
5.In the Editing group, click the arrow on Sort & Filter.
Similar questions