freezing a row

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seren - 30 Nov 2005 13:21 GMT

I am working on what will end up being a very long excel sheet. I have all
of my headings in the first row. I know that there is a way to keep this
first row visible as the user scrolls down through the other rows, but I'm
not sure how to do that. Can anyone help me out with this?

Thanks a bunch!
Seren

Signature

"Behave like a duck- keep calm and unruffled on the surface but paddle like
hell underneath."

Reply to this Message

Paul B - 30 Nov 2005 14:10 GMT

Seren, select A2 then window, freeze panes

Signature

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

>I am working on what will end up being a very long excel sheet. I have all
> of my headings in the first row. I know that there is a way to keep this
[quoted text clipped - 3 lines]
> Thanks a bunch!
> Seren

Reply to this Message

Seren - 30 Nov 2005 14:35 GMT

Thanks a bunch :)
Seren

Signature

"Behave like a duck- keep calm and unruffled on the surface but paddle like
hell underneath."

> Seren, select A2 then window, freeze panes
> >I am working on what will end up being a very long excel sheet. I have all
[quoted text clipped - 4 lines]
> > Thanks a bunch!
> > Seren

Reply to this Message