Excel’s Freeze Panes feature can keep the top row visible while you scroll down a long worksheet. It is especially useful when row 1 contains column headings that you need to reference while reviewing data farther down the sheet.
Freeze the top row in Excel
- Open the worksheet.
- Select the View tab.
- Choose Freeze Panes.
- Select Freeze Top Row.
- Scroll down to confirm that row 1 stays visible.
Unfreeze it later
Return to View > Freeze Panes and choose Unfreeze Panes. This removes the frozen boundary but does not change cell contents, formatting, or formulas.
If your headings are not in row 1
Freeze Top Row always targets the worksheet’s first row. If headings begin lower in the sheet, select the cell immediately below the rows you want to keep visible and use the general Freeze Panes command instead.
Freeze rows and columns together
To keep both header rows and identifying columns visible, select a cell below the rows and to the right of the columns that should remain fixed, then choose Freeze Panes. Excel freezes the rows above and columns to the left of the selected cell.
Freezing is different from printing repeated headings
Freeze Panes affects on-screen scrolling. If you want a heading row printed at the top of every page, use Page Layout > Print Titles and configure rows to repeat at top.
If Freeze Panes seems unavailable or behaves unexpectedly, check whether you are editing a protected/shared scenario, working in Page Layout view, or have split panes enabled. Return to Normal view and remove splits before troubleshooting the freeze position.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.