How to freeze rows and columns

Posted on December 10, 2014

To freeze a row or column, on the “VIEW” tab, under the “Window” section click “Freeze panes”. Here I’ll select to Freeze the first column.

Now I can scroll to the right and still see the row headings. Now I want to do the same for the column headings. To freeze any row of choice, mark the row underneath the one you want to show, click “Freeze Panes” again and select “Freeze Panes”.

Now you can see that that the 4^th row has been frozen and I can scroll down and still see which column belongs to which month. To freeze both the row that has the column names and the column that has the row names, mark the cell to the right of the column and underneath the row you want to freeze and select “Freeze Panes”.

Now both the row and the column headers keep still when I scroll my document.