Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Hide Freeze Pane Guideline

  1. #1
    Join Date
    17th October 2005
    Posts
    83

    Hide Freeze Pane Guideline

    When using the freeze panes excel places a guidline that appears at the top of the scrollbar but this can spoil the presentation.

    Anyone know if there is a way to hide this line - i only want to freeze pane but no need for the guideline.

    Any help appreciated.

    Thanks
    Last edited by Dave Hawley; January 5th, 2007 at 14:30.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Hide Freeze Pane Guideline?

    FreezePanes is a property of Windows, but there doesn't appear to be a Visible property of the division line - it would need to be another property of Windows. So I don't think this possible. But of course having said that, someone will find a way...

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,698

    Re: Hide Freeze Pane Guideline?

    Doubt it can be done. The only thing I can think of is to format the top row to blend in.

  4. #4
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Hide Freeze Pane Guideline?

    Quote Originally Posted by Dave Hawley
    Doubt it can be done. The only thing I can think of is to format the top row to blend in.
    If you format the cells above and below the dividing line to be black, the divider line stays black and is thus invisible - but you now have in effect a much wider dividing line... Even hiding rows or reducing row height to zero does not get rid of it.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Freeze Pane In Listbox
    By rmcareid in forum EXCEL HELP
    Replies: 1
    Last Post: April 28th, 2007, 04:55
  2. Freeze Pane Without Selecting Cells
    By ravenswood in forum EXCEL HELP
    Replies: 1
    Last Post: September 13th, 2006, 03:28
  3. VBA Freeze Pane
    By jxuereb in forum EXCEL HELP
    Replies: 4
    Last Post: December 14th, 2005, 06:19
  4. Freeze Pane unavailable in window menu
    By Karim in forum EXCEL HELP
    Replies: 1
    Last Post: November 8th, 2005, 03:52

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno