Freeze Table
 

I wish to be able to create a list in excel (of course)
where there is a header a range of rows (about 20) and then
a footer at the end of the list.

What i need though is that the header and the footer will stay constant
and the data is what will scroll with the scroll bar.

is this possible if so how.

WStoreyII

Thanks Again

Freeze Table
 

Hi
for the header:
- goto the cell directly below your heading row
- goto 'Windows - Freeze Panes'

For freezing the footer: Not possible in Excel


--
Regards
Frank Kabel
Frankfurt, Germany


WStoreyII wrote:
I wish to be able to create a list in excel (of course)
where there is a header a range of rows (about 20) and then
a footer at the end of the list.

What i need though is that the header and the footer will stay
constant and the data is what will scroll with the scroll bar.

is this possible if so how.

WStoreyII

Thanks Again