Split screen

B

Black87Bird

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

Duke Carey

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

Gord Dibben

Not without adding a window.

Top window can contain static row(s) using Window>Freeze Panes.

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


Gord Dibben MS Excel MVP
 
B

Black87Bird

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

Gord Dibben

Window>New Window.

Window>Arrange>Horizontal.

Adjust window sizes to suit.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Reading view 1
Split cells next to 1 cell 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Mis-performing MP4 files in Mac PPT 1
Format column widths from one table to a separate table on same page 1
FULL SCREEN WITH TOOLBAR ACCESIBILITY 1
Easiest Way To Insert an Activity (Task) 0

Top