Back to Excel Rows and Columns menu

Freezing rows and columns of the spreadsheet


a table with data before freezing panes

Step by step instructions:
1. Locate the meeting corner (the intersection) of the heading row and the heading column (in the above example: cell B5).
2. Select the cell that is in the inner part of that corner by clicking it (in our example: cell C6).
3. Choose the “View” tab from the ribbon.
4. Click the “Freeze Panes” button, and choose the first option (“Freeze Panes”).

Now you can scroll the window freely, the heading rows and columns will stay.

If you wish to cancel this, get back to the “Freeze Panes” button, and you can now choose “Unfreeze Panes”.


When should you freeze panes?
Lets assume that we scroll downwards the table given above.
The moment the header row went out of the screen, we have lost the month indicators, and we are barely able to know what column relates to what month:

the table after scrolling it downwards


The problem gets worse when scrolling to the right, as can be seen here:

The table after scrolling it to the right

The table has no meaning now, just a stack of numbers.

The solution is to freeze the header row and column, so no matter how you scroll it, they remain on the screen, allowing you to relate the numbers to the corresponding month and employee, as can be seen in the following image:

the table after scrolling it when applying the freeze panes

You can see that although rows 6-9 are missing, and columns C-F are missing due to the scrolling, the header row (5) and header column (B) are still visible, enabling us to relate the numerical data to its corresponding month and employee.