How to Freeze a Cell in Excel Without Losing Your Place

To keep headings or identifiers visible while you scroll in Excel, select the cell just below and to the right of the rows and columns you want to keep, then choose View > Freeze Panes > Freeze Panes. Excel does not freeze one standalone cell; it freezes the rows above and columns to the left of your selection. This is useful for keeping table labels in view on a large worksheet.

What You’ll Need

An Excel workbook with the worksheet you want to work on. The steps below are for Excel for Microsoft 365 on Windows.
A clear idea of which top rows and left-hand columns should remain visible as you scroll.
To make changes, the worksheet must not be in a state that prevents editing, such as being protected with restrictions on the relevant action.

You do not need to select or format the cells you want to freeze, and freezing panes does not change or lock the worksheet’s contents. It only changes how the sheet is displayed as you move around it.

Step-by-Step

Open the worksheet and identify what should stay visible. Look at the top and left edges of the data. For example, a sales table might have a title and column labels in rows 1 and 2, with names or dates in column A. Decide whether you need only the headings, only the identifying column, or both. You can freeze multiple adjacent rows and columns, but the frozen areas must begin at the top and left edges of the sheet.
Choose the cell at the boundary of the areas to freeze. Excel keeps every row above the selected cell and every column to its left visible. It does not freeze the selected cell itself. If you want to keep rows 1 and 2 and column A visible, click B3: row 3 is the first row that should scroll, and column B is the first column that should scroll. If you want to freeze rows 1 through 4 and columns A through C, select D5.
Select that cell on the worksheet. Click it once so it is the active cell. Check the Name Box, to the left of the formula bar, if you want to verify the address. Avoid selecting a whole row, a whole column, or a range; an individual cell makes the intended boundary clear. If the worksheet is scrolled away from the top-left corner, you can still select the required address by using the Name Box.
Open the Freeze Panes menu. On the ribbon, select the View tab. In the Window group, choose Freeze Panes. Depending on the ribbon width, the command may appear as a button or within a small menu in that group.
Apply the pane setting. Choose Freeze Panes from the menu—not Freeze Top Row or Freeze First Column unless one of those presets is exactly what you need. The Freeze Panes command uses your active cell to determine which rows and columns remain in place.
Check the result by scrolling. Use the mouse wheel, scroll bars, or keyboard to move down and across the worksheet. The rows above your chosen cell should remain at the top, and the columns to its left should remain along the left side. A thin boundary line marks the edge of the frozen area. If the wrong headings or columns remain, unfreeze the panes and repeat the process with the correct boundary cell.
Use a preset when it matches your layout. To keep only the first row visible, select View > Freeze Panes > Freeze Top Row. To keep only column A visible, choose View > Freeze Panes > Freeze First Column. These presets do not combine both choices; use the main Freeze Panes command when you need a custom combination.
Remove the setting if you no longer need it. Select View > Freeze Panes > Unfreeze Panes. After the current freeze is removed, select a new boundary cell and apply Freeze Panes again if you want a different arrangement. Save the workbook to retain the worksheet view for later use.

For example, suppose row 1 contains a report title, row 2 contains field names, column A contains employee names, and the data continues across many columns and down hundreds of rows. Select B3 and apply Freeze Panes. The two heading rows and the names column stay visible, while the rest of the table can scroll. Selecting A3 instead would keep the two heading rows but no left-hand data column; selecting B1 would keep column A but no rows above the data.

On Excel for Mac, select the boundary cell and use the View tab and Freeze Panes menu in the same way; the exact ribbon layout can vary by Excel version. In Excel for the web, open the View tab and use Freeze Panes; available menu choices can depend on the current web interface. If you cannot find the command, widen the Excel window or look for it within the View tab’s window controls.

Common Mistakes

Selecting the cell you want to keep visible. The selected cell sets the split point. Excel freezes rows above it and columns to its left, not the selected cell. For headings in rows 1 and 2 and an identifier in column A, use B3 rather than A1 or B2.
Choosing the wrong preset. Freeze Top Row handles row 1 only, and Freeze First Column handles column A only. Neither is a replacement for the custom Freeze Panes option when you need several rows and columns together.
Expecting a middle row or column to stay fixed by itself. Freeze Panes works from the top and left edges. It cannot pin row 20 while rows 1 through 19 scroll independently, or hold column F while columns A through E move.
Thinking freezing protects data. Frozen panes do not prevent edits, deletions, or changes to cell values. Use worksheet protection or other appropriate controls if your goal is to restrict editing.
Applying a new boundary without clearing the old one. Excel generally allows one frozen-pane arrangement per worksheet at a time. Unfreeze the existing panes first, then select the new boundary cell and apply the setting again.
Misreading the boundary line. A divider may sit below or to the right of the frozen area and can be subtle. Scroll both vertically and horizontally to confirm exactly which rows and columns stay in place.

Tips

Write down the boundary before clicking. State the last row and column that should remain visible, then select the next row and next column. For example, to keep rows 1–3 and columns A–B, choose C4.
Freeze only what helps navigation. Several frozen rows or columns reduce the portion of the screen available for scrolling data. Keep the frozen area compact, especially on a laptop display.
Use Freeze Panes for two-way navigation. If a table is both wide and long, freezing a header row and an identifying column lets you scroll vertically and horizontally without losing context.
Check the active worksheet. Freeze settings apply to the current worksheet, not automatically to every sheet in the workbook. Repeat the setup on each sheet where it is useful.
Consider the view for other readers. The frozen arrangement affects how the sheet appears when someone opens it, but it does not rearrange the data. Tell collaborators which rows and columns are intentionally fixed if the view could surprise them.
Distinguish pane freezing from formula references. If by “freeze a cell” you mean keeping a reference fixed when copying a formula, use an absolute reference such as $A$1 instead. That is a formula behavior, not a View-menu setting.

Troubleshooting

The wrong rows or columns are frozen. Choose View > Freeze Panes > Unfreeze Panes, then select the cell immediately below and to the right of the intended frozen area. For two header rows and one left column, select B3. Apply Freeze Panes and test the result again. The row number and column letter of the selected cell determine the split.

The Freeze Panes command is unavailable or grayed out. First press Enter or Esc if you are editing a cell, then click an ordinary worksheet cell. Check whether the worksheet is protected or whether Excel is displaying a dialog or another mode that blocks ribbon commands. Close the dialog or leave the mode, and try again. If the sheet is protected, ask the workbook owner about permission before changing its protection settings.

Scrolling seems to move the entire sheet. Confirm that you applied a freeze option rather than selecting a different view command. Then look for the pane divider and scroll within the worksheet. If the divider is not present, use Unfreeze Panes and set the boundary again. Also check that the scroll position is not already at the top or far left, where movement may be difficult to notice.

There is a thick line, but it is in the wrong place. The line marks the boundary, not the cell to be frozen. If it is below row 2, rows 1 and 2 are frozen; if it is after column A, column A is frozen. To change the line, unfreeze the current panes and reapply the setting from the correct cell.

The layout changes after opening another sheet or workbook. Freeze panes are worksheet-specific. Click the sheet tab where you want the behavior, set its panes there, and save the workbook. If a collaborator sees a different display, confirm they opened the same worksheet and that the workbook was saved after the view was set.

Frequently Asked Questions

Can I freeze just one cell in Excel?
No. Freeze Panes keeps rows above and columns to the left of a selected boundary cell visible. To keep a particular single cell in view, you would need to arrange the worksheet so that it falls within a frozen top row or left column; Excel cannot pin an arbitrary isolated cell.

How do I freeze the top two rows?
Select a cell in row 3, such as A3, then choose View > Freeze Panes > Freeze Panes. The first two rows stay visible while the rows below them scroll. The Freeze Top Row preset freezes only row 1.

How do I freeze the first column and top row at the same time?
Select B2, then choose View > Freeze Panes > Freeze Panes. Row 1 remains at the top and column A remains at the left. Do not choose either single-area preset if you need both at once.

Can I freeze a column other than column A?
You can freeze the columns from A up to a chosen boundary, but not one column by itself while earlier columns scroll. For example, select D1 to keep columns A through C visible. Use Unfreeze Panes first if another pane arrangement is already active.

Does freezing panes change the printed worksheet?
No. Freezing panes changes the on-screen scrolling view; it does not set print titles or alter page breaks. To repeat headings on printed pages, use the page layout or print-title settings separately.

Can I freeze panes in Excel for the web or on a Mac?
Yes. In both, select the boundary cell and look for Freeze Panes on the View tab. Menu placement and available options can vary by version, but the boundary rule is the same: rows above and columns to the left remain visible.

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.