![]() |
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? |
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