In a wide room-booking register, row 1 contains field names and column A holds booking IDs. Select B2, the first cell below the headers and to the right of the IDs.

Freeze the panes at the selected cell

In Ulet choose View → Freeze Panes → Freeze Panes at Selection. If your real workbook has two heading rows, use B3 to keep both. For just one edge, choose the matching top-row or first-column option.

B2 is the first moving cell under the header and to the right of the ID column.

Illustrated freeze boundary.

Scroll in both directions

Scroll down to a later record and verify you can still name the current column. Scroll right and check that its booking ID stays visible. If the boundary is wrong, unfreeze and select it again. Save and reopen the XLSX, then repeat both scroll checks.

A later booking and a farther-right field still share the visible header and booking ID.

Illustrated two-direction scroll check.

Related Microsoft Excel reference