Filtering whole range when filter is applied to two columns only

**ABSTRAKTUS** · 12-09-2010, 12:17 PM

Hi all,

How to filter a whole range when filter is applied to two columns only. There are over 100 columns in a range.

Thanks

**ChemistB** · 12-09-2010, 12:28 PM

Filtering hides entire rows so it will automatically filter all columns even if you only have the filter set on a few columns.

**ABSTRAKTUS** · 12-09-2010, 12:34 PM

I don't know what's gone wrong, but in my workbook filter works on the column it is applied to. Other columns remain untouched.

**ABSTRAKTUS** · 12-09-2010, 01:06 PM

Actually filter filters data but sorts only columns it is applied to.

**NBVC** · 12-09-2010, 01:10 PM

Do you have blank headers in some columns?

Try, unfiltering, then select all the columns, then re-apply filter.

**ABSTRAKTUS** · 12-09-2010, 01:27 PM

Filter, applied to ALL columns works fine (filtering & sorting), when applied to one column, it filters entire worksheet but sorts only the column it is applied to. I have checked column headings. None of them are blank. What might be wrong?

**ChemistB** · 12-09-2010, 01:32 PM

Yes, if you are talking about sorting, then you need to select all the columns that you want sorted (CNTRL SHFT * is a shortcut to select the range if they are contigious).

another option is typing your range into the name box i.e. B2:J450 and hitting enter.