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!