Excel: column headings

[Invisible]

Not quite sure where to ask this, but...

I've seen this done before, and I'd like to know how it was done. I saw an
Excel workbook where the column headings don't scroll with the rest of the
data. That is, the first row of cells always stay at the top of the picture.
How do you do this?

Thanks.

(I'm using Excel 97, if that makes a difference.)

 

[Bob I]

Goto Window, Split.

For complete instructions try Help, and look up "Freeze"

 

[Shawn Casey]

Look up "Freeze Panes" in the help.

 

[Jerry]

You want to freeze the panes. You do this by highlighting
the farthest cell to the left of your spreadsheet, below
the rows you want to stay in place. Click tools and then
click freeze panes. That should you.

 

[Invisible]

You want to freeze the panes. You do this by highlighting

the farthest cell to the left of your spreadsheet, below
the rows you want to stay in place. Click tools and then
click freeze panes. That should you.

It took me a while to work out that "freeze panes" is actually under the
"windows" menu, but hey, it works!

Thanks muchly.

 

[Beth Melton]

Believe it or not there is some logic behind the location of the
Freeze Panes command - you are freezing 'panes' in the 'window'.
<grin>

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~
Beth Melton

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/