My Autofilter Setting is correct?

Hello, everyone. For example, my Autofilter range is from A1 to Z100. Best method is setting range from A1 to Z100. But I don't want see Autofilter button. So I tried to set range A1 to A100. In case...

excel

dscheikey
Jun 01, 2024
Kazuhito777
Excel recognizes neighboring ranges with the autofilter command and tries to capture them completely. If you have an empty column B and click on the autofilter in column A, Excel will only create the filter in column A.
If a contiguous area is recognized that does not correspond to your ideas for the filter, you must first select your area.

So you have done everything right. 🙂

dscheikey

Bronze Contributor

Jun 01, 2024

Kazuhito777

Excel recognizes neighboring ranges with the autofilter command and tries to capture them completely. If you have an empty column B and click on the autofilter in column A, Excel will only create the filter in column A.

If a contiguous area is recognized that does not correspond to your ideas for the filter, you must first select your area.

So you have done everything right. 🙂

Kazuhito777
Copper Contributor
Jun 01, 2024
Dear dscheikey,

Thanks for your reply.
I thought so.

Thank you,
Kazuhito

Forum Discussion

My Autofilter Setting is correct?

Resources