Limit the number of rows for a filter

**guilbj2** · 05-31-2005, 11:08 AM

I'm filtering data in two columns c5:c3 and d5:d31. It's essentially a managers name and language code. The idea is to filter stats for a particular team or language. I've got my formulas working properly, but I've got some totals in rows b33:i33 through b38:i38 that I want to remain in place when I filter. I've tried auto filters, but they kill all the data that I want to remain static. Is there any way I can filter these columns (I only know autofilter right now) but get it to only filter information through row 31 ?

**swatsp0p** · 05-31-2005, 11:34 AM

Try placing a blank row above row 38 and exclude that area from your autofilter area by highlighting your columns of data in rows 5:36 and then applying the filter.

HTH