Horizontal split

[D'oug]

Office 2003

I can do a vertical split window, but I've also seen worksheets in which you
could scroll down a page but still keep the header rows at the top visible,
to keep the column descriptions visible.

If anyone can explain how that's done, I'd greatly appreciate it.

thanks.
doug

 

[Nick Hodge]

Doug

Window>Freeze Panes

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[D'oug]

Nick, Thanks. I have one more question.

I tried this, by selecting Rows 1 - 7 along the left edge of the
spreadsheet, thinking that this would 'freeze' the panes at Row 7. It
actually froze them at Row 12, and put a Vertical freeze at Column H.

Any idea why it would select that Row/Column?

Thanks.
doug

 

[Nick Hodge]

Doug

You only need to select the row you want to freeze above or a single cell
which will freeze rows above and columns to the left (Did you take the
splits off before setting?)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Ragdyer]

See if this old post will give you a little more insight into using this
feature:

http://tinyurl.com/2qdzt