Scroll by fixing the head of a row or column
When scrolling cells, you may want to scroll with the column or row headers fixed. Here's how to do that.
Confirmed version of the operation
Supported Excel version
Make sure Excel version
If you have rows or columns that you want to pin when scrolling, make the Next Matrix Cell selected for the matrix you want to pin.
In the example shown on the right, we want to fix the first two rows of rows and two columns of columns, so select the cell "C3" in the third row and third column.
Select the View tab and click Pin Window Frame in the Windows group. Select "Fix Window Frame" from the menu that appears.
A black line will appear on the grid. This will be the matrix that will be fixed when scrolling.
If you actually scroll, you'll see that the matrix is fixed. To un pinned, if you display the same menu as before, the menu is set to "Un-lock window frame", so you can select it and cancel it.