ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freeze panes just splits my page into quadrants (https://www.excelbanter.com/excel-discussion-misc-queries/75844-freeze-panes-just-splits-my-page-into-quadrants.html)

[email protected]

Freeze panes just splits my page into quadrants
 
when what I really want it to do is freeze the first column. How can I
change it?


Ken Johnson

Freeze panes just splits my page into quadrants
 
Hi,
I think you should:
1. Unfreeze the panes
2. Select B1
3. Freeze the panes

If you want just column a frozen

Ken Johnson


Ken Johnson

Freeze panes just splits my page into quadrants
 
Hi Joe,
Select B1 before freezing the panes.
Ken Johnson


Biff

Freeze panes just splits my page into quadrants
 
Hi!

Unfeeze panes, select cell B1, then try it again!

The panes will be frozen at the column to the left and the row above the
selected cell.

If you select cell B2, both column A and row 1 will be frozen.

Biff

wrote in message
oups.com...
when what I really want it to do is freeze the first column. How can I
change it?




[email protected]

Freeze panes just splits my page into quadrants
 
Thanks all. Biff the B2 tip was excellent, thanks.


Biff

Freeze panes just splits my page into quadrants
 
You're welcome. Thanks for the feedback!

Biff

wrote in message
oups.com...
Thanks all. Biff the B2 tip was excellent, thanks.





All times are GMT +1. The time now is 01:30 AM.

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