Freeze Data in Excel: Keep Rows and Columns Visible

To keep headings visible while you scroll in Excel, select the cell just below the rows and to the right of the columns you want to keep on screen, then choose View > Freeze Panes > Freeze Panes. For a single header row or first column, use the matching Freeze Top Row or Freeze First Column option. Freezing panes changes what stays visible on screen; it does not lock or protect the cell contents.

This guide covers Excel for Microsoft 365 on Windows. The steps are similar in current Excel for Mac and Excel for the web, though the ribbon layout and available options can vary slightly. The feature applies to the current worksheet, so repeat the setup on other sheets as needed.

What You’ll Need

An Excel workbook with the worksheet you want to scroll through.
A clear idea of which top rows and left-hand columns should remain visible. For example, decide whether you need one row of headings, several rows of report information, or both headings and identifying columns.
Access to the View tab. You do not need to change formulas, move data, or enable a special setting before freezing panes.

Step-by-Step

Open the worksheet and check its layout. Click the worksheet tab that contains the data. Look at the top rows and leftmost columns, and identify the exact parts you need to keep visible while navigating. Freeze Panes keeps rows above and columns to the left of a selected cell in place. It does not pin a row or column in the middle while allowing the ones before it to scroll independently.
Choose the cell below and to the right of the area to freeze. If you want to keep the first row and first column visible, select cell B2. If you want the first three rows and first two columns to stay visible, select C4. In general, to freeze the first N rows and first M columns, select the cell in column M+1 and row N+1. The selected cell itself is not frozen; the rows above and columns to its left are.
Open the Freeze Panes menu. On the Windows ribbon, select View > Freeze Panes in the Window group. Choose the first menu item, also named Freeze Panes, to freeze both the rows above and columns to the left of your selected cell. Make sure you are choosing this general option when freezing a custom combination, rather than one of the preset options below it.
Use a preset when you only need one edge of the sheet. To keep just the top row visible, select View > Freeze Panes > Freeze Top Row. To keep just the first column visible, choose View > Freeze Panes > Freeze First Column. These presets are convenient for simple lists. If you need multiple rows or columns, use the selected-cell method in the previous steps instead.
Check that the freeze worked. Scroll down or across using the mouse wheel, scroll bars, or trackpad. Frozen rows remain at the top as you move down the worksheet, and frozen columns remain on the left as you move to the right. A thin line across the sheet or down the sheet boundary marks the edge of a frozen area. Confirm the labels remain visible alongside the data you are reviewing.
Adjust the selection if the wrong area stays in place. Excel freezes based on the active cell when you choose Freeze Panes. If you accidentally selected D5 instead of C4, for example, Excel will keep three columns and four rows above that cell visible. Choose View > Freeze Panes > Unfreeze Panes, select the correct cell, and apply Freeze Panes again.
Save the workbook if you want to retain the view. Save the file normally after confirming the layout. Pane settings are associated with the worksheet and can be retained when the workbook is saved. Other people opening the workbook may see the same frozen areas, so consider whether the setup will help them too. Freezing panes does not change the underlying values, formulas, formatting, or print layout.

Example: Suppose a worksheet has a two-row title and heading section, followed by many records. The first column contains customer names, and the second contains account IDs. Select C3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 and columns A and B stay visible as you scroll through the records. If you want to keep only the headings and not the identifying columns, select A3 and use Freeze Panes instead.

Common Mistakes

Selecting the row or column to freeze rather than the next one. To freeze row 1, select a cell in row 2 before using the general Freeze Panes command. To freeze column A, select a cell in column B. Selecting A1 does not freeze row 1 and column A; there are no rows above or columns to the left of A1.
Choosing a preset that does not match the goal. Freeze Top Row freezes only the first row, even if you have selected a cell lower down. Freeze First Column freezes only column A. For a custom combination of multiple rows and columns, select the appropriate cell and choose the general Freeze Panes command.
Expecting to freeze a row or column in the middle by itself. Excel freezes a continuous block starting at the top or left edge. If you select a cell in row 8, rows 1 through 7 are included; you cannot freeze row 8 alone while rows 1 through 7 scroll.
Confusing frozen panes with protection. Frozen rows and columns remain visible, but users can still edit their cells unless the worksheet is separately protected. Likewise, freezing a pane does not stop someone from changing or deleting data.
Forgetting that each worksheet has its own view. Applying Freeze Panes on one sheet does not automatically apply it to every sheet in the workbook. Switch to each worksheet that needs the same setup and freeze its panes separately.

Tips

Keep the frozen area compact. Freezing several rows and columns can use up a large part of the visible worksheet, especially on a small screen. Keep only the labels needed to understand the data, such as a short header and one identifier column.
Use Freeze Panes for wide and long lists. For a tall list, freeze the header row. For a wide report, freeze the names or categories in the first column. If you need both, select the cell at the intersection just below and to the right of the areas to keep visible.
Make the frozen labels descriptive. Freeze Panes preserves visibility, not clarity. Use concise headings that identify what each column contains, and make sure the first columns carry useful row labels. This helps when the visible data is far from the top-left corner.
Unfreeze before redesigning the layout. If you insert or remove rows or columns near the top or left edge, check whether the frozen boundary still makes sense. Unfreeze the panes, select the new boundary cell, and set them again if the worksheet structure has changed.
Distinguish a freeze from a split. Split divides the worksheet window into separate scrollable panes. Freeze Panes keeps specified top rows and left columns stationary while the rest of the sheet scrolls. For a typical data table with headings, Freeze Panes is usually the simpler choice.

Troubleshooting

Nothing appears to happen when you scroll. Check whether the right worksheet is active and whether the frozen area is large enough to notice. A frozen first row may be hard to distinguish if the sheet is only a few rows long. Scroll farther down or across, and look for the boundary line that marks the pane.
The wrong rows or columns stay visible. The active cell was probably in the wrong place when you applied the setting. Choose View > Freeze Panes > Unfreeze Panes, click the cell immediately below and to the right of the desired frozen area, and apply the general Freeze Panes command again.
Freeze Panes is unavailable or the menu shows Unfreeze Panes. A freeze may already be active. Choose View > Freeze Panes > Unfreeze Panes first, then make a new selection and set the panes again. If the command is still unavailable, check whether the workbook is in a restricted editing state or whether the current Excel window or view is limiting ribbon commands.
Frozen panes disappeared after opening the file elsewhere. Verify that the workbook was saved after the change and that you reopened the same file, not an earlier copy. Excel for Mac and Excel for the web have similar freeze controls, but the menu layout can differ. On Mac, use the View tab and its Freeze Panes menu. In Excel for the web, open View and look for Freeze Panes; if an option is not available in your current browser layout, open the workbook in the desktop app.
The frozen area takes too much screen space. Unfreeze the panes and select a cell closer to the top-left corner. For example, if you froze four rows but only need the heading row, use Freeze Top Row. Then scroll again to check that enough worksheet remains visible for comfortable reading.

Frequently Asked Questions

Can I freeze more than one row or column?
Yes. Select a cell below all the rows and to the right of all the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Excel freezes the continuous top and left blocks before that cell.

Can I freeze rows and columns at the same time?
Yes. Select the cell at the lower-right corner of the area you want to keep visible. For example, select C3 to keep rows 1 and 2 and columns A and B in place, then use the general Freeze Panes command.

Can I freeze the bottom row or a middle column only?
No. Freeze Panes keeps rows from the top and columns from the left edge. It cannot pin a bottom row or isolate a middle row or column while the preceding worksheet area scrolls.

Does freezing panes lock cells from editing?
No. It only changes the scrolling view. To restrict editing, use Excel worksheet protection separately and configure which cells users can change.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This returns the worksheet to normal scrolling without deleting or moving any data. You can then apply a different freeze setup if needed.

Will frozen rows appear on printed pages?
Not automatically. Freeze Panes affects the on-screen view, not page printing. To repeat headings on printed pages, use the print settings for repeating rows or columns rather than relying on a frozen pane.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.