![]() |
Freeze Pane command freezes more cells than I selected.
I wish to freeze only row #1 on my worksheet.
When I highlight the row and select FREEZE PANE from the Window menu, Excel puts a cross divider down the center of my worksheet (the horizontal divider arbitrarily ends at row 14, and the vertical divider ends at column J). Now, not only is row 1 frozen, but rows 2-14 are frozen as well. Any suggestions as to why such a thing might be happening? Thanks in advance. |
Sheryl,
Try selecting the row *under* the row that you want to freeze HTH Sandy -- to e-mail direct replace @mailintor.com with @tiscali.co.uk "Sheryl" wrote in message ... I wish to freeze only row #1 on my worksheet. When I highlight the row and select FREEZE PANE from the Window menu, Excel puts a cross divider down the center of my worksheet (the horizontal divider arbitrarily ends at row 14, and the vertical divider ends at column J). Now, not only is row 1 frozen, but rows 2-14 are frozen as well. Any suggestions as to why such a thing might be happening? Thanks in advance. |
All times are GMT +1. The time now is 10:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com