| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Freeze/Split Multiple Panes in one Worksheet
You can't freeze multiple regions of a worksheet.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JL" wrote in message oups.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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Freeze/Split Multiple Panes in one Worksheet
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" wrote in message oups.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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Freeze/Split Multiple Panes in one Worksheet
You can achieve this by paying around with New Window.
"JL" wrote in message oups.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" wrote in message oups.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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Any way to get Freeze Panes to work with Split View? | Excel Discussion (Misc queries) | |||
| Multiple "Freeze Panes" one one worksheet | Setting up and Configuration of Excel | |||
| split panes / freeze and zoom | Excel Discussion (Misc queries) | |||
| Freeze and split panes in Excel 2003 | Excel Worksheet Functions | |||
| Can I have multiple freeze panes in one worksheet? | Excel Worksheet Functions | |||
![JL[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
