Freeze top and bottom rows (Excel 2003)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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,

Reply | Quote

Nope.

Reply | Quote

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

Reply | Quote