ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sectional Freezing Panes (https://www.excelbanter.com/excel-discussion-misc-queries/130933-sectional-freezing-panes.html)

Chalda

Sectional Freezing Panes
 
I know how to 'Freeze Panes' in order to maintain a particular row at the top
of the worksheet while scrolling.

Is it possible to lock a row while scrolling through rows 2-100, then lock a
different row for rows 101-200, and so on?

Gord Dibben

Sectional Freezing Panes
 
Chalda

Not possible.

One freeze per worksheet only.


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 12:44:12 -0800, Chalda
wrote:

I know how to 'Freeze Panes' in order to maintain a particular row at the top
of the worksheet while scrolling.

Is it possible to lock a row while scrolling through rows 2-100, then lock a
different row for rows 101-200, and so on?




All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com