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

I want to filter my spreadsheet but do not want column A to filter.

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

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 DataFilter.

--
Regards,
Fred


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

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

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.

Kesbutler wrote:

I want to filter my spreadsheet but do not want column A to filter.

--

Dave Peterson

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

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.

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

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.

"Fred Smith" wrote:

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 DataFilter.

--
Regards,
Fred


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

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

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.

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

The filter affects the entire row. That's the way excel works.

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.




--

Dave Peterson

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

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.