Freeze/Split Multiple Panes in one Worksheet

[JL]

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 Pearson]

You can't freeze multiple regions of a worksheet.


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

 

[JL]

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

 

[Jo HAN]

You can achieve this by paying around with New Window.