hiding freeze pane reference lines

M

Mamachugh

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.
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top