Forum Discussion
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 of this method, display result is correct. Probably, Excel recognize table range(from A1 to Z100). I want to ask you that my method is correct?(Setting range from A1 to A100 only)
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. 🙂
2 Replies
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. 🙂- Dear dscheikey,
Thanks for your reply.
I thought so.
Thank you,
Kazuhito
