For large worksheets, you may wish to visually freeze a row—to lock it into place so that it stays on your screen even as you scroll. Freezing a row locks that row, and all rows above it, on your screen when you scroll vertically (up and down). Often worksheets with table header rows are frozen at the table header row so that the header information stays on the screen.
Freeze a row or rows to keep key information visible, like a summary table in your header. Or freeze your overall project details at the top so that you can see how changes to the ETAs of project tasks below affect your overall project completion date. For instance, in the animation below we can see our total Estimated Revenue and the opportunity furthest out, changing these in the table below will affect our summary at the top.
How to Freeze Rows
Your worksheet will freeze your selected row and all rows above it. For instance, if you select row 3 to freeze, you will freeze rows 1, 2, and 3. You can always move rows to the top, before you freeze them, to reduce how many rows are frozen.
Once you have decided which rows to freeze, there are two ways to freeze rows. Select the first row in your worksheet or select a lower row, and either right-click on the row header and select Freeze row or navigate to View > Freeze and select 1 row, 2 rows, or Up to current row. If you use the View > Freeze option and select 1 or 2 rows, only freeze the first or first two rows in your worksheet will be frozen. However, selecting Up to current row will freeze all rows up to the one you have selected
|Freeze: Via right-click on the row header||Freeze: Via View menu|
Once you have frozen a row or rows, a thick line will appear beneath the last frozen row and scrolling will keep all rows above that line visible.
Note: Any new freezes override the previous freeze. For instance, if you choose to switch from freezing the top three rows to just the top row. Also, you cannot freeze so many rows that the ones beneath them cannot be scrolled down to and viewed. If you see an error like the one below, you need to freeze fewer rows. If you want to freeze a row, you might move it further up in your table and then freeze from its new location.
How to Unfreeze Rows
You can unfreeze rows the same way you freeze rows. Select one or more of the frozen rows and either right-click and select Unfreeze row, or navigate to View > Freeze > No rows.
In the animation below we freeze the third row, highlight the visual line that appears under the frozen rows, demonstrate what this looks like when you scroll, and unfreeze the rows.