Freeze bottom row

[st]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I wish to freeze the top row, left column and bottom row. Can I do this? I know how to freeze top row and left column by clicking cell below row and to right of column and freezing. However I also want the bottom row of the spreadsheet frozen so it is visible. Thanks

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I wish to freeze the top row, left column and bottom row. Can I do this? I
know how to freeze top row and left column by clicking cell below row and to
right of column and freezing. However I also want the bottom row of the
spreadsheet frozen so it is visible. Thanks

No, as far as I know it is only possible to freeze a single contiguous range
of horizontal rows and a single contiguous range of columns. It is an
interesting idea and you should request this from Microsoft by using send
feedback in the help menu.

 

[JE McGimpsey]

I wish to freeze the top row, left column and bottom row. Can I do this? I
know how to freeze top row and left column by clicking cell below row and to
right of column and freezing. However I also want the bottom row of the
spreadsheet frozen so it is visible. Thanks

You can't do that, but you *can* sort of fake it -

-Freeze top and left row
-Create a new window (Window/New Window).

-In the second window, hide the toolbar, freeze the left column
-scroll to the last line.

-Size and position the windows to have the last line window
under the main window.

One major problem with this, of course, is that the windows won't scroll
(left-right) together.

Another is that with the Elements Gallery, the second window takes up a
significant amount of screen real estate.

Not a great solution, but it may work for some.

 

[st]

I wish to freeze the top row, left column and bottom row. Can I do this? I
know how to freeze top row and left column by clicking cell below row and to
right of column and freezing. However I also want the bottom row of the
spreadsheet frozen so it is visible. Thanks

You can't do that, but you *can* sort of fake it -

-Freeze top and left row
-Create a new window (Window/New Window).

-In the second window, hide the toolbar, freeze the left column
-scroll to the last line.

-Size and position the windows to have the last line window
under the main window.

One major problem with this, of course, is that the windows won't scroll
(left-right) together.

Another is that with the Elements Gallery, the second window takes up a
significant amount of screen real estate.

Not a great solution, but it may work for some.[/QUOTE]

Many thanks

 

[st]

Many thanks.

 

[st]

Many thanks