Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Freeze top and bottom rows (Excel 2003)

    Hi Loungers,

    Is it possible to freeze the top row and the bottom row so that the columns heading and the totals are always visible.
    This way I could simply scroll through the rows in between.
    Is there a way to achieve this ?

    Thanks in advance
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Freeze top and bottom rows (Excel 2003)

    No, you can only freeze row(s) at the top and column(s) on the left hand side. There is no way to freeze row(s) at the bottom or column(s) on the right hand side.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Freeze top and bottom rows (Excel 2003)

    A workaround would be to add the totals in a row above the headings that way both the headings and the totals will always be available

    Steve

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Freeze top and bottom rows (Excel 2003)

    If its totals you want to view in the bottom row, another workaround is the Watch Window. Choose Tools | Formula Auditing | Show Watch Window. Supply the window the row(s) that contain the formulas and it will display the calcs no matter where you are in the worksheet.
    Regards,
    Rudi

  5. #5
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Freeze top and bottom rows (Excel 2003)

    Hi All,

    Thank for looking into this. I was hoping that we can somehow hack or Excel may have a hidden feature in this.

    cheers,
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Freeze top and bottom rows (Excel 2003)

    Nope.

  7. #7
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Freeze top and bottom rows (Excel 2003)

    You can do what you want, just not the way you want to do it.

    You asked about freezing the top and bottom rows. As others have said, you cannot do that. No hidden feature. Freezing windows is a particular feature and it works as advertised.

    But if all you want to do is see the top and bottom row while you scroll in between, you need a feature that's not used alot but it's not hidden.

    Here's what you do:
    1. Freeze the window so you can see the header row, as the Freeze feature allows you to do.
    2. On the Window menu, choose New Window. This will create a new window (not surprising). The title bar of the original window now has :1 appended after the file name (eg, if your title bar was showing a file name of "ABC.xls", it now has "ABC.xls:1"). The title bar of the new window has :2 after the file name. Interesting to note that this new window does NOT have frozen panes.
    3. On the Window menu again, choose Arrange and presumably you'd want the Horizontal arrangement.
    4. Fix your 2 windows, now of equal size and one on top of another, however you want. For example, if the :1 window is on bottom, you may want to move this to the top (this is the one with the frozen header rows). You may want to resize the windows so the :2 window just shows the last row(s) you want and make the :1 window bigger to show more rows.

    You may want to do step #1 last so that you freeze the window (the :1 window or the :2 window), whichever it is, that comes out on top. This way, you don't have to move the windows around in step #4.

    When you're done, close one of the windows. The remaining window "loses" its ":-number" in the title bar (ie, if you closed the :2 window, the open window loses the :1).

    As stated, it seems, at least for Excel 2003, you can keep opening new windows and deciding what to freeze. That is, each new window does NOT seem to inherit the frozen attribute. At least that's the way it worked for me in 2003 with 2 windows.

    HTH

    Fred

Posting Permissions

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