A large sheet is difficult to interpret when scrolling hides both the column headings and the record names. Freeze Panes can hold those labels on screen while the rest of the worksheet moves.

This guide uses desktop Excel for Windows. Decide exactly which rows and columns must remain visible. Freezing an oversized introductory block can leave too little space for the records you are trying to read.

Choose the cell at the moving area’s corner

Excel freezes the rows above and columns to the left of the selected cell. For example, if rows 1–2 contain the headings and columns A–B identify each record, select C3 and choose View, Freeze Panes, Freeze Panes.

The selected cell is not itself part of the fixed block. That small distinction explains many cases where one heading row or identifying column unexpectedly scrolls away.

If an existing freeze does not match your intended boundary, choose Unfreeze Panes first, select the correct cell and apply the setting again. Work from the sheet’s top-left area so the labels and boundary are easy to inspect.

Test both scrolling directions

Scroll down far enough that the first data rows disappear. The column labels should remain. Then scroll right far enough to reach a distant field; the record identifiers should remain visible on the left.

Pick a non-sensitive sample record and follow it across the sheet. Confirm that the fixed labels help you read the correct row rather than simply occupying screen space.

Freeze Panes is a viewing aid. It does not lock the cell contents against editing and does not establish which labels repeat on a printed page. Configure print titles separately when preparing paper or PDF output.

Save and reopen the workbook to check the intended working view. When handing it over, explain the frozen boundary so another user can adjust it deliberately if they use a smaller screen or need a different part of the sheet.

References: Microsoft: freezing rows and columns.