Question

what are the steps to filter data? in excel....​

Answer 1

click in upside aarow to bring it and then fill it

Answer 2

☆ Answer ☆

Filtering Separates that data that matches the given criteria.

The steps to filter the data are :-

1. Click on anything in the table/range. For example, A19.

2. On Home tab, in Editing group, click on the Sort and Filter.

3. Click on Filter option.

4. Small arrows are added to each field name to filter data.

5. Click on drop-down Arrow of A18 i.e. 'Roll No' field and select the desired value in Number Filters section (by clicking on the check boxes).

6. Click on OK button.

7. The list gets filtered and is displayed.