making a set of excel rows scroll on the page

[Benoni2]

I have an excel form where I would like several rows on the top of the page and several rows on the bottom of the page to remain stationary on the page while I scroll through the middle sells. This is very similar to freeze panes or split feature in excel, except I want to be able to do it twice. I can freeze some at the top and have the rest of the scrolling page, but I want to be able to freeze the bottom cells as well and just work on cells in the middle which will scroll and be able to give me additional rows for entry. I have talked to those who have seen it done, but can't figure it out.

 

[SkipVought]

Hi,

Place the ENTIRE data range on a SEPARATE SHEET.

Insert Vertical Scroll Bars from the Control Toolbox.

Reference the new sheet from each cell in the scroll area with a Cell Ref containing the row offset variable from the scroll bar. Keep in mind that there are 2 scroll variables, small and large.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[Benoni2]

Thanks so much for the response. I need a little bit more description of how to do this.

"Reference the new sheet from each cell in the scroll area with a Cell Ref containing the row offset variable from the scroll bar. Keep in mind that there are 2 scroll variables, small and large."

Sorry if I am being slow.

Thanks!

 

[SkipVought]

For instance...

Sheet1 is the dashboard

Sheet2 has the data

On Sheet1
rows 1-10: static heading
rows 40-45: static footing

rows 11-39: scroll data
use the Forms Scrollbar (right click toolbar and select Forms)
Min: 0
Max: (your number of data rows on Sheet2) - 1
Inc: 1
Page: 30 (40-10)

CellLink: Sheet3!A2 (i have this cell named ScrOff)

A11: =OFFSET(Sheet2!$A$1,ROW()-11+ScrOff,COLUMN()-1,1,1)

That ought to get you started.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[SkipVought]

BTW,

Max: (your number of data rows on Sheet2) - PageRowCount


Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[misscrf]

I would just freeze the panes at the top, scroll down to the bottom, and double click that little gray line above the vertical scroll bars. It splits the pane for you.

It is just to the right of the formula bar. Yuo can move it down to as many rows as you will need to see at the end, and use it's scroll bar to get to the end numbers u need to see.

Another easy way to get that split is Window | Split. Just grab the gray line and drag it to the bottom. Freeze the top and you are set.

misscrf

It is never too late to become what you could have been ~ George Eliot

 

[Benoni2]

Hey thanks so much for help Skipvought!