In desktop Excel on Windows, use View > Freeze Panes > Unfreeze Panes if a freeze is already in place. Select the cell immediately below the rows and to the right of the columns you want to keep visible. Then choose View > Freeze Panes > Freeze Panes.
01Reset the freeze on the worksheet you are using
Section linkOpen the worksheet with the problem and go to View > Freeze Panes. If the menu offers Unfreeze Panes, select it before setting a new boundary. Bring the top-left of the sheet into view so you can see your headers and the first columns while you choose where to freeze.
02Pick the cell on the scrolling side of the boundary
Section linkExcel keeps the rows above the selected cell and the columns to its left visible. For example, select B3 to keep rows 1 and 2 and column A on screen. Then choose Freeze Panes. If your headings occupy multiple rows, use the selected-cell command so you can keep all of them visible. Scroll down and to the right to check both edges.
03Check whether the worksheet is split
Section linkIf you see separate regions of the same sheet that scroll independently, check View > Split. If Split is active, click it again to remove the divider. Set the freeze boundary again and scroll through the data. A split is useful for comparing distant areas of one sheet. A freeze keeps the headers or identifiers at the edge of the view.