Autofilters in Excel

This is a recent question that I received from one of our readers, Peter.

Question: Can we apply filters on more than one table on the same worksheet?

Answer: No, we cannot have more than one Auto-filters on a same sheet. Even if the tables are separated by blank row(s), one cannot have auto filters applied on 2 tables at a same time. This issue has not been covered in Office 2007 also.

The only way, that I think, can make this possible is through VBA coding. Though I can do some basic coding, but have never tried it.

Does anyone interested in trying out this code? Or does anyone know any other way around this issue?

RELATED POSTS

2
comments:

In Excel 2007 using the insert table option you can have different filters in different tables as long as they are not in the same rows. ex. One table A1:G15 and second table B17:H45 you can filter them separately if they are converted to the tables feture!

Wednesday, August 19, 2009

This is a recent question that I received from one of our readers, Peter.

Question: Can we apply filters on more than one table on the same worksheet?

Answer: No, we cannot have more than one Auto-filters on a same sheet. Even if the tables are separated by blank row(s), one cannot have auto filters applied on 2 tables at a same time. This issue has not been covered in Office 2007 also.

The only way, that I think, can make this possible is through VBA coding. Though I can do some basic coding, but have never tried it.

Does anyone interested in trying out this code? Or does anyone know any other way around this issue?

2
comments:

In Excel 2007 using the insert table option you can have different filters in different tables as long as they are not in the same rows. ex. One table A1:G15 and second table B17:H45 you can filter them separately if they are converted to the tables feture!