I have a rather large Excel document (45,000 lines) that I must manually
review, and in specific cases refer to other lines in the general vicinity
that occur either above or below it. What I am trying to discover is if
there is a way to have the row I am actively in always remain "centered"
instead of the default method in which, as you scroll down and hit the bottom
line visible on your monitor from that point on as one line is added at the
bottom as on is taken from the top. Does anyone have a suggestion of how I
can accomplish this? Please help!
Thanks!

(This was copied and pasted from the help. It doesn't do exactly what you
want, but I think it will still help you)

View two parts of a sheet at the same time:

At the top of the vertical scroll bar or at the right end of the horizontal
scroll bar, point to the split box.

When the pointer changes to a split pointer , drag the split box down or to
the left to the position you want.

"Brian" wrote:

I have a rather large Excel document (45,000 lines) that I must manually
review, and in specific cases refer to other lines in the general vicinity
that occur either above or below it. What I am trying to discover is if
there is a way to have the row I am actively in always remain "centered"
instead of the default method in which, as you scroll down and hit the bottom
line visible on your monitor from that point on as one line is added at the
bottom as on is taken from the top. Does anyone have a suggestion of how I
can accomplish this? Please help!
Thanks!

hi,
no i don't think you can do that.
WindowFreeze Pane would let you scroll down (not up) while freezeing a row
but you would constantly have to unfreeze and refreeze the active row.
just a suggestion.
Windownew window. this will open 2 windows of the same file. then
WindowArrangehorizontal. this would stack the windows one on top of the
other.
you could use the top window as your "active" row and the bottom window to
scroll up or down. you would have to scroll the top window to move down the
sheet.

best suggestion i can think of. any one else.

Regards
FSt1

"Brian" wrote:

I have a rather large Excel document (45,000 lines) that I must manually
review, and in specific cases refer to other lines in the general vicinity
that occur either above or below it. What I am trying to discover is if
there is a way to have the row I am actively in always remain "centered"
instead of the default method in which, as you scroll down and hit the bottom
line visible on your monitor from that point on as one line is added at the
bottom as on is taken from the top. Does anyone have a suggestion of how I
can accomplish this? Please help!
Thanks!

Brian,

This isn't exactly what you want, but I'd recommend getting a roller mouse -
the kind with the little roller between the left and right buttons. They're
great for scrolling through data.

Eric

"Brian" wrote:

I have a rather large Excel document (45,000 lines) that I must manually
review, and in specific cases refer to other lines in the general vicinity
that occur either above or below it. What I am trying to discover is if
there is a way to have the row I am actively in always remain "centered"
instead of the default method in which, as you scroll down and hit the bottom
line visible on your monitor from that point on as one line is added at the
bottom as on is taken from the top. Does anyone have a suggestion of how I
can accomplish this? Please help!
Thanks!