Freeze Headers and Navigate Long Sheets in Microsoft Excel

Quick answer: Freeze panes to keep headers beside scrolling data, split a worksheet to compare distant rows, and hide rows only when you want to temporarily remove them from view. These are three different operations; none deletes the hidden or off-screen data.

Version and platform: Microsoft 365 Excel for Windows desktop; Mac, Excel for the web and Excel 2013 interfaces not covered. Use a disposable workbook for the exercise.

Create navigation markers

In a blank sheet enter Record, Item, Region and Amount in A1:D1. Put 1 in A2 and 2 in A3, select those two cells and drag the fill handle to A31 to create record numbers 1–30. Enter Marker in B2 and Last marker in B31. Put 10 in D2 and 40 in D31; these two amounts will help identify the ends of the list.

The task is to keep the heading and Record column visible while scrolling, compare the first and last records, then hide and restore a block of intermediate rows. Save a practice XLSX copy before changing the view.

Freeze the header and identifier

Select B2, then choose View → Freeze Panes → Freeze Panes. Excel freezes rows above and columns to the left of the active cell: row 1 and column A should stay visible. Scroll down until record 30 is visible. Scroll horizontally far enough to move the ordinary columns; if necessary scroll into empty columns beyond D. The heading row and Record column must remain in place.

For a changed-boundary test, choose View → Freeze Panes → Unfreeze Panes, select C3 and freeze again. This time rows 1–2 and columns A–B stay fixed. That is deliberately too much for the intended view and demonstrates how the active cell controls both boundaries. Unfreeze before the next exercise.

Split to compare distant rows

Select row 10 by its row heading, then choose View → Split in the Window group. The horizontal split divides the view so the worksheet can be scrolled in separate areas. Keep the upper pane near row 2 and scroll the lower pane to row 31. You should be able to compare Marker/10 and Last marker/40 without repeatedly jumping between the ends.

Change D31 from 40 to 45 in the lower view. This edits the same worksheet, not a second copy: the value at D31 is now 45 whichever pane displays it. Use View → Split again to remove the split. Splitting differs from freezing because it gives separate scrollable views rather than fixing a header region. Do not leave both view experiments mixed together when diagnosing a boundary problem.

Hide and restore a row block

Select row headings 5 through 8, right-click and choose Hide. The row numbers should jump from 4 to 9. This is a visibility change, not a deletion or a filter based on record values.

To restore the block, select the surrounding row headings 4 through 9, right-click and choose Unhide. Check that rows 5–8 and their Record markers return. If you select only row 9, you have not deliberately surrounded the hidden interval; use both neighbors to make the target clear. Hiding rows is not a confidentiality measure, since they can be shown again.

Leave a useful saved view

With the split removed and all rows restored, select B2 and freeze the intended header/identifier boundary again. Save and reopen the XLSX file. Scroll to check that row 1 and column A remain visible, and confirm D31 is 45. If the wrong rows stay fixed, unfreeze and select B2 anew. If records seem missing, inspect row-number gaps before assuming the data was lost. Freeze panes does not set repeated print headings; that is a separate print-layout task.

Official references

• Freeze panes to lock rows and columns
• Split panes to lock rows or columns in separate worksheet areas
• Hide or show rows or columns

Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.