StarDestroyer.Net BBS

E.g. I have a column or row that I always want to display (like the name row) no matter how far I scroll down or left/right.

What's the technical term for this?

I have found this site very useful in the past:

Link

In fact, I think the first question in the list might be right up your alley.

I think you can do this with split viewing panes. Just above the vertical scrollbar, and just to the right of the horizontal scrollbar, you should see two little widgets that you can click and drag on. For example, for your name row, you'd use the horizontal pane splitter (the one just above the vertical scrollbar) such that the top pane included the first row with the names, and then the bottom pane would let you view the rest of the spreadsheet.

Let me know if you want screenshots.

just click the cell or line underneath the one you want to always see, then
select the window drop down-->Freeze panes

YOU WIN!

you sir are a true excel god