Fitering affects the entire sheet.

If a filter on any column hides some rows, those rows will be hidden in all
columns.


Gord Dibben MS Excel MVP

On Fri, 27 Jul 2007 14:38:03 -0700, Kesbutler
wrote:

Yes. I know how to apply the filter but when you filter any column, column A
does not stay stationary it moves with the appied filter.

"Jim Rech" wrote:

Select the range you do want to filter (e.g., B1:D10) and add the
autofilter.

--
Jim
"Kesbutler" wrote in message
...
I want to filter my spreadsheet but do not want column A to filter.