How to Freeze a Group of Cells in Excel with Freeze Panes

To keep a group of rows and columns visible while you scroll in Excel, select the cell immediately below and to the right of the area you want to keep on screen, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above and the columns to the left of that cell. You cannot freeze an arbitrary block of cells independently; Freeze Panes keeps whole top rows and left-side columns visible, which is useful for headings and labels in a large worksheet.

What You’ll Need

An Excel workbook containing the worksheet you want to work with. These instructions are for Microsoft Excel for Microsoft 365 on Windows.
A clear idea of which top rows and left columns must stay visible. For example, you might keep rows 1–3 and columns A–B on screen while scrolling through the rest of a table.
Access to the View tab. You can use the desktop app or Excel for the web; the menu wording and available options can vary slightly by version.

Step-by-Step

Open the correct worksheet. Open the workbook and click the sheet tab that contains the data. Freeze Panes applies to the active worksheet only, so repeat these steps on any other sheet where you need a frozen area. If the workbook has several similar sheets, check the tab name before changing the view.
Decide what should remain visible. Identify the rows at the top and the columns on the left that contain headings, dates, names, or other reference information. For example, if rows 1 through 3 contain a title, a reporting period, and column headings, and columns A and B contain an ID and a product name, you may want to keep all five of those rows and columns visible while navigating the data.
Find the boundary cell. Click the cell that is one row below the last row to freeze and one column to the right of the last column to freeze. To keep rows 1–3 and columns A–B visible, click C4. The selected cell itself is not frozen; it marks the upper-left corner of the area that will scroll. Rows above it and columns to its left stay in place.
Check the selection before applying the command. Look at the Name Box, to the left of the formula bar, if you want to confirm the selected cell. It should show C4 for the example above. A selection in B4 would freeze the rows above but only column A, while a selection in C3 would freeze columns A and B but only rows 1 and 2. This boundary rule is the key to getting the right result.
Apply Freeze Panes. On Windows, select View > Freeze Panes > Freeze Panes. Choose the first Freeze Panes command in the menu, not Freeze Top Row or Freeze First Column, unless one of those preset choices is exactly what you need. Excel adds a boundary line to show where the frozen rows and columns end.
Test the frozen area. Scroll down and across the worksheet using the mouse wheel, scroll bars, or trackpad. In the example, rows 1–3 and columns A–B should remain visible while the cells starting at C4 move. Check both directions: scrolling down tests the frozen rows, and scrolling horizontally tests the frozen columns.
Adjust the view if necessary. If the wrong number of rows or columns stays visible, choose View > Freeze Panes > Unfreeze Panes, click the correct boundary cell, and apply Freeze Panes again. Unfreezing does not remove data or change the worksheet contents; it only removes the current scrolling boundary.

Example: Suppose a sales worksheet has a report title in row 1, month names in row 2, column headings in row 3, a sales region in column A, and a salesperson in column B. Click C4, then apply Freeze Panes. When you scroll to a later row or move right to see additional months, the report headings and the two identifying columns remain available for context.

If you only need one type of heading to stay visible, use a preset instead. To keep just row 1 visible, choose View > Freeze Panes > Freeze Top Row. To keep just column A visible, choose View > Freeze Panes > Freeze First Column. Those presets do not freeze a custom number of rows or columns; use the main Freeze Panes command for a custom combination.

Common Mistakes

Selecting the area to freeze instead of the boundary cell. If you want rows 1–3 and columns A–B frozen, selecting or highlighting A1:B3 is not the instruction Excel needs. Select C4. The active cell tells Excel how many complete rows above and columns to the left should stay in place.
Clicking the wrong preset. Freeze Top Row freezes only the top row, and Freeze First Column freezes only the first column. They will not preserve a multirow header or two identifying columns. Select the cell at the correct boundary and choose the main Freeze Panes option for that layout.
Expecting an arbitrary cell block to remain visible. Freeze Panes cannot pin a middle section, such as D5:F8, while the cells around it scroll. It works from the top and left edges of the worksheet. If you need to compare distant sections, consider opening a second window for the workbook or using split panes instead.
Forgetting an existing freeze. A previous freeze setting can affect the result you expect. Before setting a new boundary, check the Freeze Panes menu for Unfreeze Panes. Unfreeze first, then select the new boundary cell and apply the command again.
Assuming the selected cell is frozen. In the C4 example, C4 belongs to the scrolling area. The frozen portion consists of rows above C4 and columns to its left. If C4 itself contains a heading you need to keep visible, move that heading into a row or column that will be included in the frozen area, or revise the boundary.
Confusing freezing with protecting a worksheet. Freeze Panes affects what remains visible during scrolling. It does not lock cells against editing, prevent users from changing values, or protect formulas. Use Excel’s sheet protection features separately if you need editing restrictions.

Tips

Use the smallest useful frozen area. Keeping many rows and columns fixed can leave little room for the data you want to inspect, especially on a laptop display. Freeze only the headings and identifiers that you regularly need to reference.
Make headers easy to interpret. Freeze Panes preserves visibility, not meaning. Give columns clear labels and avoid relying on merged headings that make it difficult to tell which data belongs to which category. A concise header row often works better than freezing a large title area.
Plan for horizontal as well as vertical scrolling. If a worksheet is wide, freeze one or more identifying columns as well as header rows. For a sheet with row 1 as the only header and column A as the identifier, select B2 and choose the main Freeze Panes command. That keeps row 1 and column A visible.
Remember that the active sheet matters. The setting is not a workbook-wide switch. If you move to another worksheet, it can have a different freeze arrangement or no frozen panes. Set each sheet according to the way its data is organized.
Use Split when you need separate views. Freeze Panes pins the top and left portions of one worksheet view. If you need to look at two distant parts of the same sheet at once, View > Split may be a better fit. Split divides the window into independently scrollable panes; it does not pin a custom middle block in the same way as a fixed header.
Know the platform difference. In Excel for Microsoft 365 on Mac, select the boundary cell and use View > Freeze Panes > Freeze Panes; the menu may be arranged differently depending on the Excel version. In Excel for the web, use the View tab and its Freeze Panes menu. If you cannot see the command, widen the window or look for a condensed ribbon menu.

Troubleshooting

The wrong rows or columns are staying visible. First choose View > Freeze Panes > Unfreeze Panes. Then count the rows and columns you want to retain and select the boundary cell one row down and one column right. For example, three rows and two columns means C4. Apply the main Freeze Panes command and test by scrolling again.

Freeze Panes appears unavailable or behaves unexpectedly. Confirm that you are in a worksheet rather than another workbook view, and make sure you have selected a single cell rather than a multi-cell range. If the workbook is in a restricted or unusual view, switch back to Normal view from the View tab and try again. In a shared or protected workbook, permissions or the current editing mode may limit changes; check whether you can edit the workbook and, if necessary, ask its owner for access.

The divider line is hard to see. Look for a thin line across the sheet below the frozen rows and another line to the right of the frozen columns. Scroll a little in each direction to confirm which part moves. If the worksheet has unusual formatting or a large zoom level, the boundary may be less obvious, so use the selected cell and the Freeze Panes menu to verify the setup.

The setting disappears when you open another sheet. This is expected because freeze settings belong to individual worksheets. Return to the original sheet to see its arrangement, or set up the other sheet separately. If the view changes after closing and reopening a workbook, save the workbook after setting the freeze and reopen it to check that the desired view is retained.

You need to freeze a middle group of cells. Excel’s Freeze Panes command cannot keep a non-edge range fixed while allowing the surrounding worksheet to scroll. If you need to compare distant areas, try View > New Window to open another view of the workbook, or use View > Split to create separately scrollable sections. These alternatives change how you view the sheet; they do not alter the underlying data.

Frequently Asked Questions

Can I freeze just one cell in Excel?
No. Freeze Panes keeps complete rows above and complete columns to the left of a selected boundary cell. It does not pin a single cell by itself or hold an arbitrary rectangular range in place.

Which cell do I select to freeze rows 1–3 and columns A–B?
Select C4, then choose View > Freeze Panes > Freeze Panes. The rows above C4 and columns to its left remain visible; the selected cell and the rest of the worksheet can scroll.

Can I freeze rows without freezing any columns?
Yes. To keep the first three rows visible and no columns fixed, select A4 and choose the main Freeze Panes command. Because there are no columns to the left of column A, only the rows above the selection are frozen.

Can I freeze columns without freezing any rows?
Yes. To keep columns A and B visible without freezing rows, select C1 and choose the main Freeze Panes command. For just column A, select B1. The row above the selection is empty, so no worksheet rows are held in place.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the scrolling boundary but does not delete, move, or edit any cell contents. You can then select a different boundary and freeze panes again.

Does Freeze Panes work in Excel for Mac or the web?
Yes. Excel for Mac and Excel for the web provide Freeze Panes controls on the View tab, though the exact menu layout can differ by version and screen width. Select the boundary cell first, then choose the custom Freeze Panes command rather than a preset if you need multiple rows and columns.

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.