Choose the information you need to keep visible
Start with a specific task: reading a long contact list, checking an invoice register or comparing monthly figures. Decide whether you need one heading row, the names in column A, or several identification columns. A larger frozen area leaves less room for the entries you are trying to read.
Microsoft defines the boundary using the selected cell: rows above it and columns to its left stay visible. This guide follows its Windows desktop instructions for Microsoft 365 and Excel 2024, 2021, 2019 and 2016. Consult the relevant product help for Mac, browser or phone menus. [1]
Imagine row 1 contains headings, column A names and column B departments. Keeping the heading and name means selecting B2. Keeping departments as well means selecting C2. These are worked examples; match the boundary to the actual layout of your sheet rather than copying a cell address blindly.
Keep the first row and column together with B2
Click B2, then select View → Freeze Panes → Freeze Panes. The first occurrence opens the menu; the second applies the boundary of the selected cell. Freezing only the top row is a different choice and will not preserve the name column at the same time. [1]
B2 works because row 1 is above it and column A is to its left. If your headings occupy two rows, B3 is the corresponding example. Thinking of the first cell outside the area you need is more useful than memorising a single shortcut.
Scroll downward, then scroll horizontally to the right. Confirm that the heading and the name column remain visible in both cases. A downward-only check will not tell you whether the identification column was also retained.
Use the boundary cell for several rows and columns
To retain the first two rows and columns, select C3 and apply the same command. Rows 1–2 and columns A–B are on the retained side of that boundary. The selected cell itself is part of the scrolling area. [1]
For a layout with four heading rows and three identification columns, D5 is a useful example. Blank introductory rows are included as well; consider whether that much space should remain visible. There is no need to delete original rows merely to change how the sheet is viewed.
On a small laptop, retaining only the heading and name may be easier to read than keeping a large introductory block. Adjust the boundary to your window size and task. This viewing decision does not require changing the values or rearranging the source records.
Unfreeze before choosing a new boundary
Choose View → Freeze Panes → Unfreeze Panes, select the new boundary cell, then apply Freeze Panes again. Separating removal from reapplication makes the change easier to check. [1]
If headings still disappear, verify the active worksheet, the selected cell and the exact menu command. In a workbook with many sheets, it is easy to apply a viewing setting to the wrong tab and then test a different sheet.
Do not sort or delete rows to fix a viewing problem. Freeze Panes concerns what remains visible while scrolling. It does not replace worksheet protection against editing, or the separate print settings used to repeat headings on printed pages.
Consider Split when you need independent views
If you need to compare a total near the top with a distant record, Split may be more useful. Microsoft describes separate areas of the same worksheet that let you scroll one area while keeping another in view. [2]
Choose View → Split; select the command again when the split is no longer needed. The selection position determines whether the division concerns rows, columns or both. For a simple fixed heading, start with Freeze Panes and avoid adding extra view controls without a reason. [2]
Finish by testing vertical and horizontal movement while reading a real record. Check that you can still associate each number with the correct name and heading. If colleagues will use the workbook, a short note about the retained boundary can make the layout easier to understand.