ExcelBanter

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

pknivens

Freezing Panes
 

Is it posible to freeze vertical and horizontal panes at the same time?
I have a large worksheet and I need to see lines 1-3 and column A at all
times. Currently this worksheet has 472 lines and columns out to AE.


--
pknivens
------------------------------------------------------------------------
pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675
View this thread: http://www.excelforum.com/showthread...hreadid=475738


Bob Phillips

Yes, put the cursor in cell B4 and then WindowFreeze Panes

--
HTH

Bob Phillips

"pknivens" wrote in
message ...

Is it posible to freeze vertical and horizontal panes at the same time?
I have a large worksheet and I need to see lines 1-3 and column A at all
times. Currently this worksheet has 472 lines and columns out to AE.


--
pknivens
------------------------------------------------------------------------
pknivens's Profile:

http://www.excelforum.com/member.php...o&userid=27675
View this thread: http://www.excelforum.com/showthread...hreadid=475738




pknivens


Well that was easy. Thanks


--
pknivens
------------------------------------------------------------------------
pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675
View this thread: http://www.excelforum.com/showthread...hreadid=475738



All times are GMT +1. The time now is 06:14 AM.

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