You can hide the rows below what you want to see.
You can also use the Camera tool to fix a dynamic image of the total row.
If you goto the QAT options-->More Commends-->All Commands you'll find the Camera tool and you can add it to the QAT. It essentially takes a dynamic snapshot of another sheet or area out of view on the same sheet. It may or may not help with your issue, but it might be worth taking a look at.
Split the window...
Activerwindow.splitrow = 20
Then display everything at the bottom in the split window while allowing you to freeze the top frame. You can then scroll through the middle with the first window.
Activewindow.splitrow = 20