What is Autofilter in Microsoft Excel?

Answer 1

The Autofilter function looks at all the contents in a column and allows you to select only those entries you want to see. It provides a drop down list containing one copy of each of the different values. You can then select which ones you want to see by clicking on the values in the drop down list.

Answer 2

The "filter" function looks at all the contents in a column and allows you to select only those entries you want to see. This can be very useful if the column only contains a few different values - perhaps yes and no or high/medium/low or bob/sally/jim/joyce/harry or jan/feb/mar/apr/may etc. You can select just one or a few values or exclude just a few values to view just the entries you are interested in. The unselected entries will be hidden until you click on the filter arrow again a select them again for display.

Answer 3

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Answer 4

It allows you to show rows of data based on the content of cells and conditions applied to them. If you had a list of salesmen and their total sales made you could do something like show all the salesmen that had made a total sales above a certain amount, or ones that had made sales under a certain amount or ones that had sales of an exact level. You can also do combinations of conditions across different ranges. So if you also had the names of the offices that they were working in, you could find all the salesmen who made over a certain amount of sales and worked in a particular office. Auto filter allows you to bring in some databasing operations into a spreadsheet.

Answer 5

Autofilter allows quick filtering by applying the facility to filter through headings on the data. You can then pick the data you want by filtering it. So you could have a list of numbers and list off all of the ones that are over a certain value. Through Autofilter a dropdown list of options will appear at the top of the selected data.

Answer 6

Select the headings and some data and then apply the filter on the Data tab. You can then set the filters you want to use.

Answer 7

It is in the Data menu under Filter on versions up to 2003, and on the Data tab on versions from 2007 onwards.