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/45761-freezing-panes.html)

LAF

Freezing panes
 

When you select Window - Freeze panes at a given cell, a black line
appears at the top of the cell and to the left of the cell. Is there a
way to freeze panes without having these lines displayed?


--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=468228


swatsp0p


I am not aware of any option to 'hide' the freeze pane line. I am sure
Excel does that to help the user find the cut-off point from scrollable
cells from 'frozen' ones.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=468228



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

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