Question

$\huge\bold\red{Hello}$
$\huge\bold\green{Brainly\:Genius}$

$\huge\bold\pink{Need\:Help}$

$\huge\bold\purple{Computer}$

✔What Is Auto Filter Commant?Explain

$\huge\bold\orange{No\:Spam}$

▶Guys if you know any better answers but could not answer in time, you are requested to comment.◀​

Answer 1

Answer:

Explanation:

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

Turn off the AutoFilter feature by selecting Filter from the Data menu and then AutoFilter from the submenu. Reset all filtering criteria by selecting Filter from the Data menu and then Show All from the submenu. Select the pull-down arrow for a field that has criteria set, and then choose the (All) option.

Excel Autofilter with VBA. Using the autofilter with VBA is an extremely powerful feature. The following traps all of the items in column A and adds that to the autofilter output. This is dynamic so as your Excel rows grow, the code adjusts accordingly. ... Excel's Autofilters are extremely useful for isolating data.

Answer 2

Answer:

It is an easy way to turn the values in excel column into specific filters based on the cell contents.

Example : by adding auto filter to the list above, it could filter the "winery" column to only display items from Beauregard.....

HOPE IT HELPS YOU MATE.....

@dhruvchaudhary38