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?
Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

2 comments:

  1. Agree, macros/vba is the only way to do it

    ReplyDelete
  2. 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!

    Stelios Tserkezis
    Greece
    www.planetexcel.gr

    ReplyDelete

Wednesday, August 19, 2009

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?

Autofilters in ExcelSocialTwist Tell-a-Friend

2 comments:

Anonymous,  August 19, 2009 at 4:07 PM  

Agree, macros/vba is the only way to do it

PlanetExcel August 26, 2009 at 2:49 AM  

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!

Stelios Tserkezis
Greece
www.planetexcel.gr

Post a Comment