When you work with a large Excel worksheet, it’s often difficult to remember exactly what information the different columns or rows in your spreadsheet contain once you begin scrolling around it and lose sight of its column and row labels. Freezing your worksheet’s rows and columns resolves this issue.
To freeze a row, select the row number or the cell in column A that’s immediately beneath the last row you want frozen. Then, click the View tab on the ribbon, click on Freeze Panes in the Window section, and select the top selection, which is Freeze Panes, from the resulting dropdown list. Excel then inserts a thin line to show where the frozen pane begins.
To freeze a column, select the column letter or the cell in row 1 that’s immediately to the right of the last column you want frozen and repeat the process outlined above.
To freeze both rows and columns simultaneously, select the cell that’s in the upper-left corner of the range you want to remain scrollable and then invoke the Freeze Panes feature.
To make all regions scrollable again, just as before click the View tab on the ribbon, click on Freeze Panes in the Window section, and select the top selection, which will now be Unfreeze Panes, from the resulting dropdown list.