Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filters
I am using a filter to display rows with a "X" in column J. Some of the rows
I always want to show,such as category titles, kinda like a default template. Is there a way i can get them to always show without having to put a "X" in the rows J cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filters
Where are the rows located?
If all at the top, just insert a blank row below the titles etc. then put your autofilter arrows on the row below that. If interspersed throughout the sheet, you will need a different function.............not autofilter. Elsewise..........use the "x" Gord Dibben MS Excel MVP On Thu, 18 Jun 2009 13:24:02 -0700, Muskrat24 wrote: I am using a filter to display rows with a "X" in column J. Some of the rows I always want to show,such as category titles, kinda like a default template. Is there a way i can get them to always show without having to put a "X" in the rows J cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filters
no, there is a category title row than 5 selections, than another category
title row and more selections. All together are 12 categories each with 5-15 selections. it won't do any good to have all the category titles on the top and all the selections mixed together. Is there a way I could make the category rows not apart of the filter? "Gord Dibben" wrote: Where are the rows located? If all at the top, just insert a blank row below the titles etc. then put your autofilter arrows on the row below that. If interspersed throughout the sheet, you will need a different function.............not autofilter. Elsewise..........use the "x" Gord Dibben MS Excel MVP On Thu, 18 Jun 2009 13:24:02 -0700, Muskrat24 wrote: I am using a filter to display rows with a "X" in column J. Some of the rows I always want to show,such as category titles, kinda like a default template. Is there a way i can get them to always show without having to put a "X" in the rows J cell? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filters
Not that I know of.
Gord On Fri, 19 Jun 2009 07:28:01 -0700, Muskrat24 wrote: no, there is a category title row than 5 selections, than another category title row and more selections. All together are 12 categories each with 5-15 selections. it won't do any good to have all the category titles on the top and all the selections mixed together. Is there a way I could make the category rows not apart of the filter? "Gord Dibben" wrote: Where are the rows located? If all at the top, just insert a blank row below the titles etc. then put your autofilter arrows on the row below that. If interspersed throughout the sheet, you will need a different function.............not autofilter. Elsewise..........use the "x" Gord Dibben MS Excel MVP On Thu, 18 Jun 2009 13:24:02 -0700, Muskrat24 wrote: I am using a filter to display rows with a "X" in column J. Some of the rows I always want to show,such as category titles, kinda like a default template. Is there a way i can get them to always show without having to put a "X" in the rows J cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
filters | Excel Discussion (Misc queries) | |||
How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Using Filters | Excel Discussion (Misc queries) |