1
Freeze the Top Row
Freeze the Top Row
How to freeze a row in Excel
Learn how to freeze rows and panes in Excel to keep your headers and key data visible while scrolling. This step-by-step guide will walk you through freezing the top row and locking panes at a specific selection.
Operations
2
Open the Excel document
Navigate to the Excel document to begin learning how to freeze a row.
3
Click the View tab
Click the View tab in the top ribbon to access view-related options.
4
Click the View tab
Click the View tab in the top ribbon to access view-related options.
5
Click the Freeze Panes button
Click the Freeze Panes button in the View tab's Window group to open the dropdown menu.
6
Click the Top Row option
Click the Top Row option in the Freeze Panes dropdown menu to freeze the first row of your spreadsheet.
7
Freeze Multiple Rows
Freeze Multiple Rows
8
Click row 5
Click the row number below the last row you want to freeze.
9
Click the Freeze Panes
Click the Freeze Panes dropdown arrow in the View ribbon to see the available options.
10
Select the Freeze at selection option
Click the "Freeze at selection" option in the dropdown menu to lock the rows above your active cell.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.