How to set the row for title to be fixed during scrolling?

[Guest]

I would like to fix the row 1,2,3 for title, and when I scroll up / down,
then title is still there without affected by page up / down.
Does anyone know how to set the row for title to be fixed during scrolling?
Thank you
Eric

 

[Paul B]

Eric, select A4 then window freeze panes

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thank you for your suggestion
Will it be possible to freeze panes for row and column at the same time?
rather than freeze only for row or column
Thank you
Eric

 

[Paul B]

Eric, yes, just select a cell to the right of the column you want to freeze,
selecting B4 will keep rows 1:3 at the top and column A on the left.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thank you very much
Eric

Eric, yes, just select a cell to the right of the column you want to freeze,
selecting B4 will keep rows 1:3 at the top and column A on the left.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003