Auto Filter

Hello Amy

Thank you for your question.

The reason that the autofilter is only filtering the first block of rows is because of the blank row. If you can do without the blank row (e.g. you could create the space simply by making a row wider/higher to create the effect of a gap), then I would delete them. Otherwise you will have to select all the data before you use autofilters so Excel will filter all the data and not just down to the point where the first blank row occurs.

I hope this helps - let me know if you have any further questions.

Amanda

Dear Amy

Thank you for your question.

It is important to understand that when you enter data in Excel it is a range which means it is a continuous flow of data.

In Excel you normally would have a blank row or a column to separate the different groups of data.

I believe that is what is happening with your data.

I am sure there must be a reason for having a blank row for the spacer. But unfortunately because of this spacer it is treating the second block as a totally different range and not the same.

If you definitely don