Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I use "filter" but keep "title" row in sight?
I have a worksheet in which the first row contains the titles of the rows.
When I use the filter option and use it the title row disapears. How can I make the title row to stay there even if I use the filter option? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I use "filter" but keep "title" row in sight?
"Erni" wrote in message
... I have a worksheet in which the first row contains the titles of the rows. When I use the filter option and use it the title row disapears. How can I make the title row to stay there even if I use the filter option? Select the rows you want to filter, then impose the filter. -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I use "filter" but keep "title" row in sight?
"David Biddulph" wrote: "Erni" wrote in message ... I have a worksheet in which the first row contains the titles of the rows. When I use the filter option and use it the title row disapears. How can I make the title row to stay there even if I use the filter option? Select the rows you want to filter, then impose the filter. -- David Biddulph Thanks for your answer. I've just noticed that I asked the question not fully correct for my purpose: First row: Title of columns Second row: Average numbers of colums Problem: if I use the filter the second row with the average numbers doesn't show anymore = how can I keep this row visible? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I use "filter" but keep "title" row in sight?
I put my titles in Row 2 and the subtotals in row 1.
Then I select A3 and use Window|freeze Panes so that rows 1:2 are always visible. And when I use the filter, I can see the subtotals in row 1 without scrolling. Erni wrote: "David Biddulph" wrote: "Erni" wrote in message ... I have a worksheet in which the first row contains the titles of the rows. When I use the filter option and use it the title row disapears. How can I make the title row to stay there even if I use the filter option? Select the rows you want to filter, then impose the filter. -- David Biddulph Thanks for your answer. I've just noticed that I asked the question not fully correct for my purpose: First row: Title of columns Second row: Average numbers of colums Problem: if I use the filter the second row with the average numbers doesn't show anymore = how can I keep this row visible? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I use "filter" but keep "title" row in sight?
"Erni" wrote in message
... "David Biddulph" wrote: "Erni" wrote in message ... I have a worksheet in which the first row contains the titles of the rows. When I use the filter option and use it the title row disapears. How can I make the title row to stay there even if I use the filter option? Select the rows you want to filter, then impose the filter. Thanks for your answer. I've just noticed that I asked the question not fully correct for my purpose: First row: Title of columns Second row: Average numbers of colums Problem: if I use the filter the second row with the average numbers doesn't show anymore = how can I keep this row visible? Select rows from 3 downwards, then filter. And,as stated elsewhere, if you want to keep the headers visible when the page scrolls, select the row below your headers, & freeze panes. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can i "filter" in excel by words in Bold? | Excel Worksheet Functions |