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?

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

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?

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

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