ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Freezing panes? (https://www.excelbanter.com/excel-programming/305215-freezing-panes.html)

HotRod

Freezing panes?
 
Is it possible to freeze more than one pane? One horizontal and one
vertical?



Tom Ogilvy

Freezing panes?
 
select D5 and then do Window = Freeze Panes

this will freeze rows 1:4 and columns A:C

as an example.

--
Regards,
Tom Ogilvy

"HotRod" wrote in message
...
Is it possible to freeze more than one pane? One horizontal and one
vertical?





bob fleming

Freezing panes?
 
Thank you very much for this simple solution - it's easy when you know
how, and for the past 9 months I didn't know how!!!

Nice one

Regards

Bob


All times are GMT +1. The time now is 05:34 PM.

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