Halfway down a stock list, the number 12 could be a quantity, a shelf number or the number of items reserved. Scrolling back to the headings every time interrupts the work. Freeze Panes keeps reference rows and columns visible while the rest of the sheet moves.
Choose the boundary, not the heading
In desktop Excel for Windows, the general Freeze Panes command keeps the rows above the selected cell and the columns to its left. Suppose row 1 contains the headings and column A contains item codes. Select B2, then choose View → Freeze Panes → Freeze Panes. That boundary leaves row 1 and column A in view.
If the headings occupy the first two rows and codes occupy the first two columns, C3 is the corresponding starting cell. This is a layout example: inspect your own sheet before choosing it. Freezing a large introductory area can leave little room for the data, especially on a laptop.
Check the view in both directions
Scroll down to a distant record and then across to the last data column. Can you still identify both the item and the field? If the boundary is wrong, use Unfreeze Panes in the same menu and choose again. Recheck after moving the table or inserting rows above it.
Freezing keeps cells in place on screen; it does not prevent someone from editing them. It also does not set up headings to repeat on printed pages. Before sending a long printout, inspect print preview separately. The useful question is the same in both places: can the reader tell what each number belongs to without returning to the beginning?