Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Location
    London
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Freeze Panes (97)

    When I freeze panes on my spreadsheet part of the column to the left of the split becomes hidden (the last couple of characters to the right of the cell). when the split is removed the column is clearly visible. This only happens when I have grouped some of the rows together (as in created an outline). Does anyone know if there is a work-around for this problem as I use both features regularly.

    Thanks in advance

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Location
    Lebanon/France
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze Panes (97)

    Did you try (after selecting the first column) Format>>Column>>Width and choose a larger number?

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Location
    London
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze Panes (97)

    Yes, I did. The columns are actually wide enough anyway.

    Try it.

  4. #4
    Star Lounger
    Join Date
    Aug 2001
    Location
    Lebanon/France
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze Panes (97)

    !!!
    What happens when you freeze the panes ?

    the column is squeezed and hides the right part of the cells
    or
    the column remains large enough to display the last digits but the right part of the cells looks like if the font became invisible?

  5. #5
    New Lounger
    Join Date
    Nov 2001
    Location
    London
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze Panes (97)

    yeah, the column shrinks and knocks off the last couple of characters on the right (see attachment)
    Attached Files Attached Files

  6. #6
    Star Lounger
    Join Date
    Aug 2001
    Location
    Lebanon/France
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze Panes (97)

    Well,
    if I open it with excel 2002, the column is perfectly displayed

    if I open it with excel 97 or excel 2000, I suppose I see what you see: the column Q is overlaped by the unfreezed part of the panes
    then I selected the column Q which width was 14.88, I enlarged it widely, the header (text) becomes visible, but the two last digits of the figures remain hidden.
    anything formatted in an horizontal right alignment is truncated....

    it looks for me like an excel bug or hidden limitation...
    I'm sorry, I cannot help

  7. #7
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Freeze Panes (97)

    ... You could change the justification for your cells losing data from right justified to either center or left. (I am sure you thought of this...)

    Another option is to use the Split feature instead of freeze panes so you don't lose the right side of the data.

    HTH
    Regards,

    Gary
    (It's been a while!)

  8. #8
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze Panes (97)

    You could also try inserting a column to the right and freezing on that instead or use a custom format on the cells and pad them out with some spaces, #,##0" "


    HTH

    Peter

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Freeze Panes (97)

    Where does the fourth outline level come from? When I Data, Group & Outline, Clear Outline, then add another fake customer, and re-run Data, Subtotals, I get only three outline levels, and the behavior goes away.
    -John ... I float in liquid gardens
    UTC -7ąDS

  10. #10
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze Panes (97)

    If John's suggestion doesn't solve your problem, then I was able to get aroung the problem by removing the Freeze pane and inserting a column after Q that has a width of 1.63 and then putting the freeze frame back which hide the newly inserted column.
    Legare Coleman

Posting Permissions

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