How do I sort or filter rows without column A data changing?

  • Thread starter Thread starter Guest
  • Start date Start date
You need to be more specific.

You can filter any column you want, so if you don't want to filter column A,
then choose another column.

If you mean you don't want to see a dropdown box in column A, then select the
columns you do want to filter before choosing Data>Filter.
 
Select the exact range you want to filter. Then apply the filter.

Don't include column A if you don't want it included in the filter.
 
So, here is what I want to do. I apply a filter to the columns I want. but
when you filter column A still filters.

What I am doing is column A is numbered 1, 2, 3.... and I want the rows to
always be in that order even if the data is filtered. but when you filter the
numbers move as with the filtered data.
 
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.
 
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
 
Back
Top