Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a column of data sort into rows? | Excel Worksheet Functions | |||
unable to filter by specific data on a column if the rows exceed 1 | Excel Worksheet Functions | |||
data sort/filter | Excel Worksheet Functions | |||
Columns A - BY and 336 rows.Too much to filter&sort?Lose info. | Excel Worksheet Functions | |||
Columns A - BY and 336 rows.Too much to filter&sort?Lose info. | Excel Worksheet Functions |