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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"D'oug" <Doug@discussions.microsoft.com> wrote in message
news:C415590D-53BB-4564-BC03-02915444828C@microsoft.com...
> 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

[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" wrote:

> Doug
>
> Window>Freeze Panes
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "D'oug" <Doug@discussions.microsoft.com> wrote in message
> news:C415590D-53BB-4564-BC03-02915444828C@microsoft.com...
> > 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

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"D'oug" <Doug@discussions.microsoft.com> wrote in message
news:886DA6F8-7074-47DB-A955-F99BD840A8AF@microsoft.com...
> 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" wrote:
>
>> Doug
>>
>> Window>Freeze Panes
>>
>> --
>> HTH
>> Nick Hodge
>> Microsoft MVP - Excel
>> Southampton, England
>> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>>
>>
>> "D'oug" <Doug@discussions.microsoft.com> wrote in message
>> news:C415590D-53BB-4564-BC03-02915444828C@microsoft.com...
>> > 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
>>
>>
>>

[Ragdyer]

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

http://tinyurl.com/2qdzt

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"D'oug" <Doug@discussions.microsoft.com> wrote in message
news:886DA6F8-7074-47DB-A955-F99BD840A8AF@microsoft.com...
> 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" wrote:
>
> > Doug
> >
> > Window>Freeze Panes
> >
> > --
> > HTH
> > Nick Hodge
> > Microsoft MVP - Excel
> > Southampton, England
> > nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> >
> >
> > "D'oug" <Doug@discussions.microsoft.com> wrote in message
> > news:C415590D-53BB-4564-BC03-02915444828C@microsoft.com...
> > > 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
> >
> >
> >