Split screen
 

Is it possible to have rows at the top and bottom of the screen remain static
and rows inbetween that scroll?
--
Regards
Tom G

Split screen
 

No - Excel will allow you to freeze rows at the top and columns at the left -
but that is it.

"Black87Bird" wrote:

Is it possible to have rows at the top and bottom of the screen remain static
and rows inbetween that scroll?
--
Regards
Tom G

Split screen
 

Not without adding a window.

Top window can contain static row(s) using WindowFreeze Panes.

Bottom window can contain the row(s) to remain static at bottom.


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 11:44:34 -0700, Black87Bird
wrote:

Is it possible to have rows at the top and bottom of the screen remain static
and rows inbetween that scroll?

Split screen
 

Nor sure how to add a window, a advise?
--
Regards
Tom G


"Gord Dibben" wrote:

Not without adding a window.

Top window can contain static row(s) using WindowFreeze Panes.

Bottom window can contain the row(s) to remain static at bottom.


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 11:44:34 -0700, Black87Bird
wrote:

Is it possible to have rows at the top and bottom of the screen remain static
and rows inbetween that scroll?

Split screen
 

Sorry, sat and though about opening another window for a minute and realized
what you were saying. Thanks, that should work well.
--
Regards
Tom G


"Black87Bird" wrote:

Nor sure how to add a window, a advise?
--
Regards
Tom G


"Gord Dibben" wrote:

Not without adding a window.

Top window can contain static row(s) using WindowFreeze Panes.

Bottom window can contain the row(s) to remain static at bottom.


Gord Dibben MS Excel MVP

On Wed, 20 Aug 2008 11:44:34 -0700, Black87Bird
wrote:

Is it possible to have rows at the top and bottom of the screen remain static
and rows inbetween that scroll?

Split screen
 

WindowNew Window.

WindowArrangeHorizontal.

Adjust window sizes to suit.


Gord

On Wed, 20 Aug 2008 14:48:01 -0700, Black87Bird
wrote:

Nor sure how to add a window, a advise?