Freeze Panes in Excel: How to Keep Rows and Columns Visible

To insert a freeze pane in Excel for Microsoft 365 on Windows, select the cell immediately below the rows and immediately to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For a single header row or first column, use the matching command in the same menu. Freeze panes keep selected headings or labels on screen while you scroll through the rest of a worksheet.

What You’ll Need

An Excel workbook with the worksheet you want to work on.
A clear idea of which rows or columns should stay visible. The freeze command uses the active cell to determine this.
Permission to edit the workbook if it is protected or opened in read-only mode. You can usually still view a frozen layout without changing it.

Step-by-Step

Open the worksheet and check its layout. Select the sheet tab containing the data. Identify the row headings, column headings, or identifier columns that you want to remain visible as you move around. For example, a long sales list might have headings in row 1 and customer names in column A. If the labels span several rows or columns, note how many you need to keep on screen.
Click the correct cell for a custom freeze. Excel freezes every row above the selected cell and every column to its left. It does not freeze the active cell itself. To keep the first two rows visible, select any cell in row 3, such as A3. To keep the first two columns visible, select a cell in column C, such as C1. To keep both the first two rows and first two columns visible, select C3. The exact contents of the selected cell do not matter; its position does.
Open the Freeze Panes menu. Select the View tab on the ribbon. In the Window group, choose Freeze Panes. Depending on the ribbon width, the command may appear as a button or inside a small dropdown. Make sure you are choosing the command on the View tab, not a similarly named option from another application.
Apply the custom setting. Choose Freeze Panes from the dropdown. Excel will draw a thin line below the frozen rows and to the right of the frozen columns. Scroll down or across to confirm that the selected headings or labels remain visible. If the line appears in the wrong place, unfreeze the panes and repeat the selection with the correct cell.
Use the one-click option for a single top row. If the only row you need to keep visible is row 1, select View > Freeze Panes > Freeze Top Row. You do not have to select a cell first. This is useful for a typical table with field names across the first row, such as Date, Product, and Amount. It freezes row 1 even if you are currently scrolled farther down the worksheet.
Use the one-click option for the first column. Choose View > Freeze Panes > Freeze First Column to keep column A visible while scrolling horizontally. This is helpful when each row has an identifying value, such as an employee name or item number. The command targets the first column only; it does not freeze multiple columns. For that, select a cell in the column immediately to the right of the columns you want frozen and use the custom Freeze Panes command.
Check the result and save the workbook. Scroll in both directions if you froze both rows and columns. Confirm that the right labels remain visible and that the rest of the sheet can still move. Save the workbook to keep the layout with the file. If other people use the workbook, tell them which sheet has frozen panes so the stationary lines are not mistaken for a data boundary.

On Excel for Mac, the corresponding commands are available from the View tab or the View menu, with options named Freeze Panes, Freeze Top Row, and Freeze First Column. The exact ribbon arrangement can vary with the Excel version and window width. In Excel for the web, open View > Freeze Panes and choose the appropriate freeze option; available menu wording or placement can vary slightly as the web interface changes. In each version, the custom option follows the same active-cell rule: rows above and columns to the left are frozen.

Common Mistakes

Selecting the row or column you want frozen instead of the cell after it. This is the most common cause of an unexpected result. To keep rows 1 through 3, select a cell in row 4 before choosing the custom command. To keep columns A through C, select a cell in column D. To keep both, select a cell in column D and row 4, such as D4. If you select A1, there are no rows above or columns to the left to freeze.

Choosing Freeze Top Row when the headings are not in row 1. That preset freezes the worksheet’s first row, not whichever row contains the headings. If your headings are in row 5, select a cell in row 6 and choose the regular Freeze Panes command. The same distinction applies to Freeze First Column: it always freezes column A, not the first column in a selected table.

Expecting to freeze a middle row or column while scrolling past it. Freeze panes work from the top and left edges of the worksheet. They can hold rows above and columns to the left of your active cell, but they do not let you pin an arbitrary row in the middle while the rows above it scroll away. If the labels you need are lower down, consider moving or copying them to the top of the sheet, or use a different worksheet layout.

Confusing Freeze Panes with Split. The Split command divides the worksheet window into independently scrollable sections. It is not the same as keeping headings fixed. If you see multiple scroll areas or divider bars and that is not what you intended, remove the split and apply Freeze Panes instead. Freeze panes create a stationary area along the top or left, rather than separate scrollable views.

Tips

Plan the freeze before selecting a menu command: count the heading rows and identifier columns you genuinely need to see. Keeping too many rows or columns fixed can leave little room for the data on a smaller screen. For many lists, freezing one header row and one identifying column is enough; for a report with a two-row heading, freeze both heading rows only if readers need both while they scroll.

When setting a custom freeze, you can click any cell at the right boundary and below the bottom boundary of the area to keep visible. For instance, if the first row and first column should stay put, B2 is the boundary cell. You do not need to choose a blank cell, and you do not need to highlight the whole area to freeze.

Use the visual divider as a quick check. The horizontal line marks the bottom edge of frozen rows, and the vertical line marks the right edge of frozen columns. These lines can be subtle, especially on a small display. Scroll a little in the worksheet to verify the behavior instead of relying only on the divider’s appearance.

Freeze panes apply to the current worksheet, not every sheet in the workbook. If several tabs contain long tables and each needs its own fixed headings, set the panes separately on each sheet. Also consider using descriptive, consistent header rows so people can understand the data when they open the workbook and scroll.

Troubleshooting

The wrong rows or columns stay visible. Choose View > Freeze Panes > Unfreeze Panes, then select the boundary cell again. For example, select C3 before applying the custom command if you want rows 1 and 2 plus columns A and B to stay visible. Scroll to the top-left of the worksheet first if it helps you confirm the intended boundaries.

The Freeze Panes command is unavailable or will not apply. First, finish editing the current cell by pressing Enter or Esc; some ribbon commands are unavailable while you are typing in a cell. Then check that the worksheet is not protected in a way that prevents the change and that the workbook is not open in a restricted, read-only state. If you are in Excel for the web and cannot change the workbook, check whether you have editing permission or open it in the desktop app if permitted.

The worksheet appears divided into several areas. You may have selected Split rather than Freeze Panes. Open the View tab and turn off Split if it is active, then use the Freeze Panes dropdown. If the display still looks unusual, choose Unfreeze Panes and set the desired freeze again.

The headings disappear when you scroll. Confirm that the freeze was applied to the correct sheet and that you did not choose a different view or workbook window. Check the menu for Unfreeze Panes; if that option is available, panes are currently frozen. If the headings are below row 1, make sure you used the custom command rather than Freeze Top Row. Save the workbook after correcting the setting.

Frequently Asked Questions

Can I freeze rows and columns at the same time?
Yes. Select the cell immediately below the rows and immediately to the right of the columns to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select C3 to freeze rows 1 and 2 and columns A and B.

How do I freeze more than one row?
Select a cell in the row directly below the last row you want to keep visible, then use the regular Freeze Panes command. To freeze rows 1 through 4, select a cell in row 5. The Freeze Top Row preset only freezes row 1.

Can I freeze columns that are not next to the left edge?
Not as a separate group. Excel freezes columns from column A through the column immediately left of your selection. For example, selecting D1 and choosing the custom command freezes A through C; it cannot freeze only column C while A and B scroll.

How do I remove a freeze pane?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen rows and columns from that worksheet. You can then apply a different layout, such as freezing only the top row.

Will the freeze stay when I close the workbook?
Save the workbook after setting the panes. The frozen view is associated with that worksheet in the saved file, so it should remain when the workbook is reopened. If it does not, check that you saved the correct file and sheet, and that another user or process did not change the view afterward.

Does freezing panes change or protect the data?
No. It changes how the worksheet is displayed while scrolling; it does not lock cells, prevent editing, or change values. Use worksheet protection separately if you need to restrict edits, and remember that freezing headings is only a navigation aid.

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.