Is there a way to have tow freeze panes in excel, one at the top and one at the bottom so that all the rows in between can be scrolled back and forth without affecting the top part of the pane and the bottom part?
The command you're looking for is under the Windows menu in Excel. what you'll need to do first is select split and put the dividers where you want them. then go back to the windows menu and select Freeze Panes.
I have done that already for to top part of the sheet. The question is how do you do this for the bottom part of that same sheet so that my sheet has two freeze panes: one top and one bottom on the same sheet?