Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
hiding freeze pane reference lines
3,625 views
Skip to first unread message
Mamachugh
Jun 26, 2009, 4:18:01 PM6/26/09
to
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.
T. Valko
Jun 26, 2009, 4:30:39 PM6/26/09
to
Can't be done.
--
Biff
Microsoft Excel MVP
"Mamachugh" <Mama...@discussions.microsoft.com> wrote in message
news:0ED8E84F-1768-4E0A...@microsoft.com...
Max
Jun 27, 2009, 6:07:01 AM6/27/09
to
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
---
Shane Devenshire
Jun 27, 2009, 6:54:02 PM6/27/09
to
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
0 new messages