My Autofilter Setting is correct?

[Kazuhito777]

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)

[#2 · Accepted solution]

@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. 🙂

[#3]

Dear dscheikey,

Thanks for your reply.
I thought so.

Thank you,
Kazuhito