Lets assume row 5, column A contains some important title. How do I
keep a row 5 stationary such that when the user scrolls down rows 6
through XX (where XX is some number up to max) will slip under (or at
least so it seems) row 5?

I've seen this done but I'm not sure how to do this.