Thanks, mysterytramp! Seven years after your post, I wanted to tell you it is *still* valuable! I, too, needed to find how to lock / freeze rows and columns. Much appreciated! Cheers - MatthewThere's an icon on the far right of the window. Click on it and you'll see "Freeze Header Columns" and you can vary the number of columns frozen.
Not an easy find. Not very intuitive. Not sure whether I found it in the documentation or possibly here on MR.