Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding freeze pane reference lines
Is there any way to hide the vertical and horizontal lines that appear after
freezing panes? I'm using an Excel spreadsheet as a form and sharing with the entire network and these just add chaos to the form. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding freeze pane reference lines
Can't be done.
-- Biff Microsoft Excel MVP "Mamachugh" wrote in message ... Is there any way to hide the vertical and horizontal lines that appear after freezing panes? I'm using an Excel spreadsheet as a form and sharing with the entire network and these just add chaos to the form. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding freeze pane reference lines
well, if its under your control, you could always creatively camouflage it
using black fill/white font for the top/left portions segmented by the panes -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Mamachugh" wrote: Is there any way to hide the vertical and horizontal lines that appear after freezing panes? I'm using an Excel spreadsheet as a form and sharing with the entire network and these just add chaos to the form. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding freeze pane reference lines
Hi,
The freeze panes line is visible even if you place a solid line over it, it appears to float on a layer above spreadsheet and the graphic layers. If you use Excel 2007 you can have one row of titles lock at the top of a table range without using the freeze pane command - that is because the titles replace the column letters as you scroll out of view of them. Personally I'd learn to live with the freeze pane lines, that are lots bigger issues. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Max" wrote: well, if its under your control, you could always creatively camouflage it using black fill/white font for the top/left portions segmented by the panes -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Mamachugh" wrote: Is there any way to hide the vertical and horizontal lines that appear after freezing panes? I'm using an Excel spreadsheet as a form and sharing with the entire network and these just add chaos to the form. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I choose which lines are frozen using "freeze pane"? | Excel Discussion (Misc queries) | |||
freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
how do I hide freeze pane lines | Excel Discussion (Misc queries) | |||
How to hide freeze pane lines? | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions |