Excel Freeze Panes: keep references and headers visible

Excel Freeze Panes keeps headings and reference codes visible as a worksheet scrolls. Build a fictional grid, test both directions and save a workbook with an observation sheet you can reopen.

Last updated: 18 October 2026.

What does Excel Freeze Panes help you read?

Excel Freeze Panes keeps selected rows and columns visible while other worksheet areas scroll. This is useful when a reference disappears off the left edge or column labels disappear above the window. You want to keep enough context to identify a value without repeatedly returning to the start.

This guide uses desktop Excel for Windows and a fictional training grid. It requires no customer list, actual orders or confidential stock information. Your output will be a named workbook containing a practice sheet and an observation sheet. The task is about reading a worksheet, not calculating or validating its contents.

No Excel interface, scrolling trial or save-and-reopen trial was executed while preparing this article. The proposed observations must be filled in by you after using your installation. A documented expected result is not evidence that a check happened. Keep unperformed checks marked Not run.

The Excel prompt guide covers a wider set of spreadsheet questions. You do not need an assistant for this exercise. First decide which identifying column and heading row must remain visible, then choose a boundary that matches that requirement.

Build a small grid with identifiable boundaries

On Windows, search Start for Excel, open it and choose File > New > Blank workbook. Double-click the first sheet tab, type Practice and press Enter. Enter Reference, Item, Units, Area, Shelf, Note and Check across A1:G1. Put one label in each cell. Do not place a title row above the labels, because row one is the only heading row in this exercise.

Fill rows two through eleven with ten invented records. Use references T01 through T10 in column A. Give each item a short fictional description and set Units to 1. Use simple invented area and shelf labels. Put End column in G2 so the right-hand test target is easy to recognize.

The agreed requirement is to retain row one and column A while scrolling. It does not ask to retain the Item column or a second heading row. Write that requirement before selecting an Excel command. Otherwise a visually plausible boundary can be mistaken for the boundary you intended.

The source grid is A1:G11. If the entire grid already fits in your window, resize the application window to create a reasonable scrolling test. Record that condition. Do not delete content or hide columns merely to produce a picture that looks like a completed test.

If you also need controlled status entries, the Excel order-status drop-down exercise is a separate job. Keeping a cell visible does not constrain the words typed into it. Finish the reading test before adding other requirements to the practice workbook.

Why is B2 the relevant boundary?

Microsoft explains that Freeze Panes retains rows above and columns to the left of the selected cell. Select B2 to retain row one and column A together. B2 is immediately below the intended row and immediately to the right of the intended column.

On Practice, select B2 and choose View → Freeze Panes → Freeze Panes. Do not substitute a top-row-only or first-column-only command and assume both requirements have been met. If an earlier freeze is present, use View → Freeze Panes → Unfreeze Panes first, then set the intended boundary.

For a useful counterexample, consider B3. It sits below two rows rather than one, so it describes a different retained area. C2 sits to the right of two columns rather than one. Neither choice is inherently wrong, but neither matches our specified one-row, one-column requirement.

If you selected the wrong boundary, undo the freeze through Unfreeze Panes and establish it again from the correct cell. Do not move source records around to make the old boundary appear correct. Record the correction so the next reader can understand the final setup.

Changing the layout changes the question. A new title above the labels, for example, means the labels are no longer in row one. In a later exercise, define the rows and columns you need before choosing a cell. Memorizing B2 without remembering the requirement will not solve every workbook layout.

Test vertical and horizontal scrolling separately

Scroll downward until the last reference row is in view. Look for the heading words at the top. Record the labels you can actually read rather than treating a boundary line as sufficient evidence. The question is whether the useful identifying text remains available during the movement.

Next scroll to the right until you can inspect the Check column. Look for the reference codes in column A at the same time. A successful vertical observation does not establish horizontal behavior. Keep separate entries for these two checks so one does not silently stand in for the other.

Then inspect a view that is both lower and farther right. Identify one visible reference and a visible value on that same row. Record the pair you read. This is a small readability check, not evidence that the invented reference belongs to a real product or that any numeric value is correct.

If there is no meaningful scrolling because your window displays the complete grid, write that down. Resize the window and run a separately described check if appropriate. Do not mark a horizontal test passed when no horizontal movement was observed. The test condition belongs beside the result.

Prepare four observation entries: vertical scrolling, horizontal scrolling, combined view and reopened workbook. Each needs Expected, Observed, Decision and Next step fields. You can prepare expectations now; leave observations blank until you execute the checks. A decision should refer to its observation, not to confidence in the menu choice.

Save the setup and its observations in one workbook

Select the + beside the sheet tabs to add a worksheet. Double-click its tab, type Notes and press Enter. Put Test, Expected, Observed, Decision and Next step across its first row. Add the four test entries underneath. In another row preserve the requirement: Practice sheet, selected boundary B2, retain row one and column A. Include the workbook filename as a separate field.

Return to Practice before saving. Choose File → Save As → Browse, select Documents and save as reference-header-practice.xlsx using the Excel Workbook format. Choose another filename if that one already exists. This is a new training workbook, so there is no reason to overwrite an earlier exercise.

Close the workbook. Open Documents in File Explorer and reopen the exact saved file. Inspect Notes first and confirm that the written requirement and observations are present. Return to Practice and repeat the vertical and horizontal checks. Enter those reopened-state observations separately from the original trial. After entering them on Notes, press Ctrl+S. Close and reopen the file, then check that the newly added Notes entries remain present.

Saving a file and checking its reopened state are different actions. Do not write that the setup persisted merely because you pressed Save. If something differs after reopening, retain the earlier observation and add the difference rather than rewriting the history to make the result appear consistent.

For handover, use: Fictional worksheet reading exercise. Workbook: [name]. Intended retained area: row one and column A. Selected boundary: [observed cell]. Vertical observation: [result]. Horizontal observation: [result]. Reopened-state result: [result or Not run]. Unresolved issue: [specific question].

The Sheets workflow guide deals with a broader process. Our workbook does not send messages, create orders or update another system. Keep the small visual setup distinct from any future automation plan.

Do not confuse visibility with protection or printing

A retained reference helps you interpret a row. It does not prove that the row is accurate, prevent someone from editing a cell or establish that every record is present. Do not label the sheet Protected or Validated based on this exercise. No calculation or access-control test has been performed.

Printed headings require a separate setting. The Excel print-header exercise concerns Print Titles and preview checks, not scrolling. A heading remaining visible on screen is not evidence that it will appear on the second printed page. Printing and PDF export are outside our practice task.

Similarly, spreadsheet edit notifications address awareness of changes. Keeping a code visible does not alert a colleague that its value changed. If change monitoring is a requirement, define it separately rather than assuming that a convenient display setting supplies that capability.

An especially wide retained area can leave little room for the moving content. In a real workbook, consider which identifier is essential rather than retaining every descriptive column. Make that decision before copying the training setup into a larger sheet with a different layout.

The practical result is modest and concrete: a saved workbook in which you can inspect the specified visual boundary and read an honest observation record. Another person should be able to identify what you wanted, what you tested and what remains untested. That is more useful than a screenshot with an unexplained claim that the whole spreadsheet is ready.