Question

how does auto filter work?
please answer me​

Answer 1

Answer:

.Use the AutoFilter feature to find, show, or hide values—in one or more columns of data. You can filter based on choices you make from a list, or search to find the data that you seek. When you filter data, entire rows will be hidden if the values in one or more columns don't meet the filtering criteria.

Answer 2

Answer:

The basic Excel filter (also known as the Excel Auto filter) allows you to view specific rows in an Excel spreadsheet, while hiding the other rows. When the Excel auto filter is added to the header row of a spreadsheet, a drop-down menu appears in each cell of the header row.

Hope this answer is helpful.....

I wish that this answer should be helpful....

Have a good day