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

To keep headings or identifying columns visible while you scroll in Excel for Microsoft 365 on Windows, select the cell immediately below the rows and to the right of the columns you want to keep, then choose View > Freeze Panes > Freeze Panes. For just the top row or first column, choose the matching command from the same menu. Freeze Panes changes what stays on screen; it does not change, move, or protect worksheet data.

Before you begin, decide which rows and columns need to remain visible and make sure the worksheet is showing the area you want to work in. The selection is important: Excel freezes everything above and to the left of the selected cell, not the selected cell itself. The guide below explains how to freeze one or both directions, undo the setting, and resolve common surprises.

What You’ll Need

A workbook open in the Excel desktop app. The instructions are for Microsoft Excel for Microsoft 365 on Windows.
A worksheet with data arranged so that the labels you need to keep visible are at the top, on the left, or in both places.
The row and column numbers for the boundary of the area to keep visible. For example, to keep rows 1 through 3 and columns A and B, you will select cell C4.

You do not need to select or format the data first, and you do not need a special worksheet layout. If you are working in Excel for the web or on a Mac, see the platform notes in the steps and FAQ; the names and placement of commands can vary slightly.

Step-by-Step

Open the correct worksheet and identify what should stay visible. Click the sheet tab that contains the list, schedule, or report you are scrolling. Decide whether you need a header row, several heading rows, an identifying column, or a combination. For instance, a sales sheet might need its column labels in rows 1 and 2 and the customer names in column A. Freeze only the parts that help you interpret the rows as you move through the sheet; freezing too much leaves less room for the data.
Click the boundary cell for rows and columns you want to freeze. Excel keeps the rows above the selected cell and the columns to its left. To freeze rows 1 and 2 only, click A3. To freeze column A only, click B1. To freeze rows 1 and 2 together with column A, click B3. To freeze rows 1 through 3 and columns A and B, click C4. The chosen cell is a boundary marker; Excel does not freeze that cell itself.
Open the Freeze Panes menu. Select the View tab on the ribbon, then choose Freeze Panes in the Window group. If the Excel window is narrow, the ribbon may compress the group or show a smaller button, so maximize the window or look within the View tab for the command. The menu normally contains Freeze Panes, Freeze Top Row, Freeze First Column, and Unfreeze Panes when a freeze is already active.
Apply the selection-based freeze. Choose Freeze Panes from the menu, not Freeze Top Row or Freeze First Column, when you want a custom boundary or a combination of rows and columns. Excel draws a thin line below the frozen rows and a vertical line to the right of frozen columns. Scroll down or across to check that the intended headings remain in place while the rest of the sheet moves.
Use the one-click options when they match your layout. To keep only the worksheet’s first row visible, choose View > Freeze Panes > Freeze Top Row. To keep only its first column visible, choose View > Freeze Panes > Freeze First Column. These commands use the actual top row or leftmost column of the sheet, regardless of the active cell. They are convenient for a simple header or a row of names, but do not use them when you need multiple rows or columns.
Check the result at a distant point in the data. Scroll far enough down to see whether the row headings remain, then scroll right if you froze a column. Confirm that the divider appears at the intended row or column boundary and that the frozen area is not so large that it crowds the visible worksheet. If the wrong area stayed put, unfreeze and repeat with the correct boundary cell.
Remove or change a freeze when needed. Return to View > Freeze Panes and choose Unfreeze Panes. Then select a new boundary cell and apply Freeze Panes again, or choose a top-row or first-column option. Excel applies one freeze-pane arrangement per worksheet, so change the existing arrangement rather than trying to add a second independent freeze.

In Excel for Mac, look for Freeze Panes under the View tab or the View menu; exact placement can differ by release. Excel for the web also provides freeze options on the View tab, though the ribbon may be arranged differently and some controls can depend on the current browser window size. If a command is missing, check that you are in the worksheet view rather than a dialog or another ribbon tab. There is no need to use a keyboard shortcut for these steps; menu commands work across the desktop platforms.

Common Mistakes

Selecting the cell you want to keep visible. The selected cell is not what gets frozen. Excel freezes the rows above it and columns to its left. If you click A1 and choose Freeze Panes, there are no rows above or columns to the left to hold in place. Select the boundary cell instead.
Choosing Freeze Top Row for a multirow heading. This option freezes only worksheet row 1. If your labels occupy rows 1 and 2, select A3 and use Freeze Panes. Similarly, Freeze First Column affects only column A, not a group of identifying columns.
Using a special option when you need a custom combination. Freeze Top Row and Freeze First Column are quick presets. They do not combine automatically. To keep a header and a name column together, select the cell just below and to the right of both areas and choose the general Freeze Panes command.
Forgetting that the freeze applies to one worksheet. A setting on one sheet does not automatically freeze the same rows on every other sheet in the workbook. Visit each worksheet where you need the behavior and set it there.
Confusing frozen panes with split panes or print titles. Freeze Panes keeps headings visible during on-screen scrolling. Split divides the worksheet window into independently scrollable areas, while print titles repeat selected rows or columns on printed pages. Use the feature that fits the task rather than expecting a screen freeze to change printouts.

Tips

Keep the frozen region compact. A wide frozen block or several tall heading rows can leave only a small part of the worksheet available for scrolling. Freeze the minimum labels needed to identify the data. You can unfreeze and adjust the boundary at any time.
Use a boundary example before selecting. Write down the last row and last column to freeze, then move one cell down and one cell right. If the last headings are in row 4 and column C, select D5. This simple check prevents the common off-by-one selection error.
Freeze before navigating far away. You can select a boundary cell even when it is not currently visible, using the Name Box to the left of the formula bar. Type the cell reference, such as D5, press Enter, and then use View > Freeze Panes > Freeze Panes. This can be easier than scrolling back to the top-left corner.
Remember that frozen rows and columns stay anchored at the sheet edges. Freeze Panes is designed for consecutive rows from the top and consecutive columns from the left. It cannot hold an unrelated middle row or a nonadjacent column in place while other areas scroll.
Save the workbook after setting up a useful view. Saving preserves the workbook changes, including worksheet view settings. When sharing a file, tell recipients which sheet has frozen headings if the layout is not obvious. They can change the view without changing the underlying cell values.

Troubleshooting

The wrong rows or columns are frozen. Choose View > Freeze Panes > Unfreeze Panes first. Work out the last row and column that must remain visible, select the cell one row below and one column to the right, and apply Freeze Panes. For example, if rows 1 through 4 and columns A through C should stay visible, select D5. Check the divider lines after applying the setting.

The Freeze Panes command is unavailable or the menu looks different. Make sure a worksheet cell is active and the View tab is selected. If the file is open in a browser, confirm that you are using Excel for the web and look for its View tab controls; some ribbon items may be collapsed at a narrow window width. In desktop Excel, maximize the window or expand the ribbon. If the workbook is in a protected or restricted state, check whether the protection settings or editing permissions prevent view changes.

Scrolling seems to move the whole sheet anyway. First check whether you are scrolling inside the intended worksheet and whether you selected the correct cell before applying the command. A freeze line may be subtle, especially with a small window or zoom level. Choose Unfreeze Panes and set it again, then scroll using the worksheet scroll bars or mouse wheel. Also check whether Split is active; if the window is divided into panes, turn off the split before setting a freeze if you want ordinary frozen headings.

Only one of the directions stayed fixed. This often happens when Freeze Top Row or Freeze First Column was chosen instead of the general Freeze Panes command. Unfreeze, select the cell at the intersection boundary, and choose Freeze Panes. To hold rows 1 and 2 plus column A, the correct selection is B3. If the selected boundary is in row 1, there are no rows above it to freeze; if it is in column A, there are no columns to its left.

The freeze does not appear on another sheet or in a printout. Set the view separately on each worksheet that needs it. For printed pages, freezing panes is not the relevant setting: use Page Layout > Print Titles and specify rows to repeat at the top or columns to repeat at the left. Print layout options and availability may vary in Excel for the web, so use desktop Excel if you need the full page setup controls.

Frequently Asked Questions

Can I freeze more than one row or column?

Yes. Select the cell below the last row and to the right of the last column you want to keep visible, then choose View > Freeze Panes > Freeze Panes. The selection freezes all rows above and all columns to the left, so it can set both directions together.

Can I freeze a row in the middle of a worksheet?

No. Freeze Panes keeps consecutive rows beginning at the top of the sheet and consecutive columns beginning at the left. It cannot keep an isolated middle row visible while scrolling past the rows above it. Consider using Split if you need independently scrollable sections, or move the headings to the top if the worksheet design allows.

How do I freeze the top two rows and the first column?

Click cell B3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 are above B3, and column A is to its left, so all three remain visible. If a different area stays fixed, unfreeze first and repeat with B3 selected.

Does Freeze Panes change what appears when I print?

No. It affects scrolling in the worksheet window only. To repeat headings on printed pages, use Page Layout > Print Titles in desktop Excel and set the rows or columns to repeat. Preview the printout because page breaks may affect how much data fits on each page.

Can I freeze panes in Excel for the web or on a Mac?

Yes. Both Excel for the web and Excel for Mac offer freeze-pane controls, though the ribbon or menu placement can differ from Windows desktop Excel. Look under View for Freeze Panes, choose the appropriate preset or custom option, and verify the divider lines. If a command is not visible, widen the window or expand the ribbon.

Will other people see my frozen panes?

The freeze is a worksheet view setting saved with the workbook, so it may be visible when another person opens the file. They can change or remove the freeze without editing the cell contents. If the view is important for using the sheet, mention it when you share the workbook.

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.