How To Freeze A Row In Microsoft Excel And Google Sheets – SlashGear

The freezing function has been available in Microsoft Excel for well over a decade now, allowing you to pin rows and columns to your view as you work. While the method we’re about to outline is intended to work with the modern version of Excel, you can freeze rows in older Excel versions roughly the same way.

1. Open a spreadsheet in Microsoft Excel.
2. Switch to the View tab in the top taskbar.
3. On the right side of the View menu, you’ll see three Freeze buttons.
4. Click Freeze Panes to freeze everything to the left of your currently-selected cell.
5. Click Freeze Top Row to freeze the topmost row of the spreadsheet.
6. Click Freeze First Column to freeze the leftmost column of the spreadsheet.
7. While Freezing is active, Freeze Panes becomes Unfreeze Panes.

To elaborate a bit further on Freeze Panes, when clicked, the button creates a kind of “reticle” at the cell you currently have highlighted. Everything above and to the left of this cell will be frozen while the rest of the spreadsheet scrolls as usual. So, for example, if you freeze at cell H10, every cell from A1 to G9 will be pinned. Whatever freeze function you use, you can disable it at any time by clicking the Unfreeze Panes button.