Excel Auto Filter

Question

Hi,

Am I missing something, I have autofilter on quick access, which I have always thought was supposed to filter by selection, but it never has it just behaves like the filter button and adds the drop downs,

do I need to do something else?

Richard.

Answer 1

Sorry I'm not with you, lets just take auto filter and filter, I have added auto filter and filter to the quick access toolbar, but they both behave the same, just add the drop down,

secondly, you say;

Click on the "Filter" button in the "Sort & Filter" group. *

Click on the "Filter by Selected Cell's Value" option.

but all that happens is I turn on and off the drop down not filter by selection is offered.

Essentially I want to filter by selection having added auto filter to the quick access, and then I should be able to invoke through ALT and position number?
Richard.

Answer 2

Sorry for the earlier replies. Apparently the system is having some issues which are mixing up platforms.

Answer 3

Hi RichardDrake!

Perhaps there seems to be a misunderstanding about how the Autofilter feature works in Excel. The Autofilter feature allows you to quickly filter data in a range or table based on specific criteria. When you enable the Autofilter feature, you will see drop-down arrows appear in the header row of each column, which allow you to select specific values to filter by.

To use the Autofilter feature: * Select the range or table that you want to filter. * Click on the "Data" tab in the ribbon. * Click on the "Filter" button in the "Sort & Filter" group. * The Autofilter drop-down arrows will appear in the header row of each column. * Click on the drop-down arrow for the column you want to filter. * Select the criteria you want to filter by from the drop-down menu.

If you want to filter by selection, you can use the "Filter by Selected Cell's Value" feature, which is also located in the "Sort & Filter" group on the "Data" tab.

This feature allows you to select a cell in the range or table, and then filter the data based on the value in that cell.

To use this feature: * Select the cell in the range or table that you want to filter by. * Click on the "Data" tab in the ribbon. * Click on the "Filter" button in the "Sort & Filter" group. * Click on the "Filter by Selected Cell's Value" option.

The data will be filtered based on the value in the selected cell.

Note that this feature only works if the cell you select is within the range or table you want to filter.

Kindly let me know, if you require additional assistance, I will be glad to help further.

Best Regards, Shakiru