Freeze/Split Multiple Panes in one Worksheet

Dear Gurus,

I want to freeze rows in a worksheet multiple times without having to
open a different worksheet. For example -

rows 1-6 are header rows I want to freeze
rows 7 through 30 are detail rows I want to scroll rough
rows 31 through 33 are total rows I want to freeze

rows 36 through 37 are header rows I want to freeze
rows 38 through 50 are detail rows I want to scroll rough
rows 51 through 53 are total rows I want to freeze

So I want to have a lot of stuff going on one worksheet - I've looked
up and down for a way to do this, and from what I've found it seems
impossible.

Any ideas?

Thanks in advance
Matt

You can't freeze multiple regions of a worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JL" <jotrocks@hotmail.com> wrote in message
news:1106332530.606173.190450@f14g2000cwb.googlegroups.com...
> Dear Gurus,
>
> I want to freeze rows in a worksheet multiple times without
> having to
> open a different worksheet. For example -
>
> rows 1-6 are header rows I want to freeze
> rows 7 through 30 are detail rows I want to scroll rough
> rows 31 through 33 are total rows I want to freeze
>
> rows 36 through 37 are header rows I want to freeze
> rows 38 through 50 are detail rows I want to scroll rough
> rows 51 through 53 are total rows I want to freeze
>
> So I want to have a lot of stuff going on one worksheet - I've
> looked
> up and down for a way to do this, and from what I've found it
> seems
> impossible.
>
> Any ideas?
>
> Thanks in advance
> Matt
>

Chip - thanks. Can you please give Bill a call and have him add that
in the next release? Thanks!


Chip Pearson wrote:
> You can't freeze multiple regions of a worksheet.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "JL" <jotrocks@hotmail.com> wrote in message
> news:1106332530.606173.190450@f14g2000cwb.googlegroups.com...
> > Dear Gurus,
> >
> > I want to freeze rows in a worksheet multiple times without
> > having to
> > open a different worksheet. For example -
> >
> > rows 1-6 are header rows I want to freeze
> > rows 7 through 30 are detail rows I want to scroll rough
> > rows 31 through 33 are total rows I want to freeze
> >
> > rows 36 through 37 are header rows I want to freeze
> > rows 38 through 50 are detail rows I want to scroll rough
> > rows 51 through 53 are total rows I want to freeze
> >
> > So I want to have a lot of stuff going on one worksheet - I've
> > looked
> > up and down for a way to do this, and from what I've found it
> > seems
> > impossible.
> >
> > Any ideas?
> >
> > Thanks in advance
> > Matt
> >

You can achieve this by paying around with New Window.

"JL" <jotrocks@hotmail.com> wrote in message
news:1106333648.357646.269490@f14g2000cwb.googlegroups.com...
> Chip - thanks. Can you please give Bill a call and have him add that
> in the next release? Thanks!
>
>
> Chip Pearson wrote:
>> You can't freeze multiple regions of a worksheet.
>>
>>
>> --
>> Cordially,
>> Chip Pearson
>> Microsoft MVP - Excel
>> Pearson Software Consulting, LLC
>> www.cpearson.com
>>
>>
>> "JL" <jotrocks@hotmail.com> wrote in message
>> news:1106332530.606173.190450@f14g2000cwb.googlegroups.com...
>> > Dear Gurus,
>> >
>> > I want to freeze rows in a worksheet multiple times without
>> > having to
>> > open a different worksheet. For example -
>> >
>> > rows 1-6 are header rows I want to freeze
>> > rows 7 through 30 are detail rows I want to scroll rough
>> > rows 31 through 33 are total rows I want to freeze
>> >
>> > rows 36 through 37 are header rows I want to freeze
>> > rows 38 through 50 are detail rows I want to scroll rough
>> > rows 51 through 53 are total rows I want to freeze
>> >
>> > So I want to have a lot of stuff going on one worksheet - I've
>> > looked
>> > up and down for a way to do this, and from what I've found it
>> > seems
>> > impossible.
>> >
>> > Any ideas?
>> >
>> > Thanks in advance
>> > Matt
>> >
>