How do I lock a row or column in Excel so when I scroll down the page the header row stays visible?

I know how to do it programmatically but I just need to do it once manually.