Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#287091 - 24/09/2006 11:29 Quick Excel97 question
pedrohoon
enthusiast

Registered: 06/08/2002
Posts: 333
Loc: The Pilbara, Western Australia
How do I make a row of cells containing column titles remain at the top of the screen while I scroll down the page?
I can't seem to find anything in the help files, looking under 'titles', 'freezing', 'headings' etc.

Thanks.
_________________________
Peter.

"I spent 90% of my money on women, drink and fast cars. The rest I wasted." - George Best

Top
#287092 - 24/09/2006 11:56 Re: Quick Excel97 question [Re: pedrohoon]
larry818
old hand

Registered: 01/10/2002
Posts: 1033
Loc: Fullerton, Calif.
Window > Freeze panes

Top
#287093 - 24/09/2006 12:07 Re: Quick Excel97 question [Re: larry818]
pedrohoon
enthusiast

Registered: 06/08/2002
Posts: 333
Loc: The Pilbara, Western Australia
Doh! Thanks for that!

Excel help is just so useless, searching the index for 'freezing' doesn't even mention 'freeze panes'
_________________________
Peter.

"I spent 90% of my money on women, drink and fast cars. The rest I wasted." - George Best

Top
#287094 - 24/09/2006 13:48 Re: Quick Excel97 question [Re: pedrohoon]
larry818
old hand

Registered: 01/10/2002
Posts: 1033
Loc: Fullerton, Calif.
The funny thing is, while I use that function all the time, it took me a half hour to remember how to do it.

In my defense, I've had no coffee this morning.

Top