Locking a Row in Excel: Step-by-Step Guide

To solve the problem of losing your place in a long Excel spreadsheet, you can freeze rows to keep the headers visible or compare data from different rows. Here’s how to do it: If your table’s header is on row 3, select row 4 to freeze rows 1 and 2. Then go to the View tab and click on Freeze Panes.

You can also freeze the first column by clicking the Freeze First Column button under View. To freeze another column, select the one to the right of where you want to freeze it and click on Freeze Panes.

To compare information, select the row below the header and click on Freeze Panes. This will keep everything above the selected row frozen while you scroll down to view other rows.

If you want to unfreeze panes, simply click on View and then click on the Unfreeze Panes button.