How to freeze a range in excel 2003and 2007

[capitokk]

I want to freeze a group of cells in excel 2007 but when I click on
the freeze panes, top row or first column: nothing happens- I mean it
scrolls up and down.
Also is there anyway I can print an excel worksheet which is several
pages long and still have the headings (which is in say the first 3
rows ie A1 - E1 down to A3 - E3) printed on each page? Lets say the
headings are on only page 1 but i want it to be on page 2,3,4 to the
last page when printed. Can freezing do that? Thanks.

 

[Roger Govier]

Hi

In order the Freeze Panes, your cursor needs to be one cell below, and one
cell the the right of the Row and column you are trying to freeze.

As far as Printing is concerned, Freeze panes has no effect.
Page Layout tab>Print Titles>Rows to repeat at top>$1:$3


--

Regards
Roger Govier

I want to freeze a group of cells in excel 2007 but when I click on
the freeze panes, top row or first column: nothing happens- I mean it
scrolls up and down.
Also is there anyway I can print an excel worksheet which is several
pages long and still have the headings (which is in say the first 3
rows ie A1 - E1 down to A3 - E3) printed on each page? Lets say the
headings are on only page 1 but i want it to be on page 2,3,4 to the
last page when printed. Can freezing do that? Thanks.

__________ Information from ESET Smart Security, version of virus
signature database 5235 (20100628) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5235 (20100628) __________

The message was checked by ESET Smart Security.

http://www.eset.com