Freeze Cells in Excel While Scrolling: A Step-by-Step Guide

How-to basics · Updated November 20, 2026

To keep headings visible while you scroll in Excel, select the cell below the rows and to the right of the columns you want to keep on screen, then choose View > Freeze Panes > Freeze Panes. Excel locks the rows above and columns to the left of that cell in place. You can also freeze just the top row or first column using the matching commands. This is useful for long lists where labels would otherwise disappear as you move through the data.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows. The instructions below also note the menu paths for Mac and Excel for the web.
  • A worksheet with data arranged in rows and columns. Decide which headings or identifying columns you need to keep visible before choosing a freeze point.
  • If you plan to freeze both rows and columns, identify the first cell that should remain scrollable. The freeze point is based on the selected cell, not on a separately typed number of rows or columns.

Step-by-Step

  1. Open the worksheet and check its layout. Click the sheet tab containing your data. If the worksheet has a title or a few introductory rows above the actual column labels, decide whether those rows should stay visible too. Freeze Panes locks every row above the selected cell, so include only the rows you need. Likewise, every column to the left of the selection will stay visible.
  2. Choose the freeze point. Click the cell immediately below the last row you want frozen and immediately to the right of the last column you want frozen. For instance, to keep rows 1 and 2, plus column A, visible, select B3. When you choose Freeze Panes, Excel holds rows 1 and 2 and column A in place; the area starting at B3 remains available to scroll. To freeze only rows 1 through 3, select A4. To freeze only columns A and B, select C1.
  3. Open the Freeze Panes menu. On Windows, select the View tab on the ribbon, then open Freeze Panes in the Window group. Make sure you have selected the worksheet cell first. The menu offers commands for freezing panes, the top row, or the first column.
  4. Apply the custom freeze. Choose Freeze Panes from the menu. This first option uses your current selection to lock the rows above and the columns to the left. It does not freeze the selected cell itself as an independent box; it creates a boundary between the fixed area and the scrollable area.
  5. Use a one-click option when appropriate. If you need only the worksheet’s top row to remain visible, choose View > Freeze Panes > Freeze Top Row. If you need only the leftmost column, choose View > Freeze Panes > Freeze First Column. These commands are intended for the top row and first column, not an arbitrary row or column farther down or across the sheet.
  6. Check the result by scrolling. Scroll down and across the worksheet. The frozen area should remain visible while the other cells move. A thin line at the edge of the fixed area marks the freeze boundary. If the wrong rows or columns remain fixed, unfreeze and repeat the selection step with the correct cell.
  7. Remove the freeze when you no longer need it. Return to View > Freeze Panes and choose Unfreeze Panes. This clears the current freeze so the whole worksheet scrolls normally. Then select a new cell and apply a different freeze arrangement if needed. Excel has one active freeze arrangement per worksheet view, so you replace it rather than stacking several separate freeze commands.

Example: Imagine a sales sheet where row 1 contains the report title, row 2 has column headings, and column A lists salesperson names. Select B3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 and column A stay visible, making it easier to identify both the salesperson and the field while reviewing later rows and columns.

Common Mistakes

  • Selecting the row or column you want frozen instead of the cell beyond it. To freeze through row 4, select a cell in row 5. To freeze through column C, select a cell in column D. For both, select the cell diagonally beyond the frozen area, such as D5 to freeze rows 1–4 and columns A–C.
  • Using Freeze Top Row for a heading that is lower down. Freeze Top Row locks worksheet row 1 only. If your labels are on row 4, select A5 and use the general Freeze Panes command to keep rows 1–4 visible. Be aware that this also freezes any title or blank rows above row 4.
  • Expecting one individual cell to remain fixed. Freeze Panes keeps whole rows above and whole columns to the left of the boundary; it cannot pin an isolated cell while the rest of its row and column scroll.
  • Trying to freeze separate, nonadjacent areas. Excel’s Freeze Panes feature locks a continuous block beginning at the top-left of the worksheet. You cannot keep row 1 and row 5 fixed while allowing rows 2–4 to scroll, for example.
  • Confusing freezing with splitting. Split divides the worksheet into separately scrollable panes. Freeze Panes instead keeps the upper and left sections stationary as you scroll the remaining area. If you want independent scrolling areas, look at View > Split, not Freeze Panes.

Tips

  • Keep the freeze area as small as practical. Freezing several title rows can use up screen space, especially on a laptop. Usually, the column labels and one or two identifying columns are enough for navigating a large table.
  • Use a real header row for structured data. If your list is an Excel table, its header row can remain visible as you scroll within the table in supported desktop versions. For a specific worksheet layout, Freeze Panes gives you control over multiple rows and columns, including content outside the table.
  • Check both directions. A setting that looks right when scrolling down may be inconvenient when scrolling far to the right. Test the sheet vertically and horizontally before sharing it, particularly if the freeze includes several columns.
  • Remember that freezing changes the view, not the data. It does not edit, sort, hide, or protect cells, and it does not change what prints. To repeat headings on printed pages, use the separate print setting under Page Layout > Print Titles.
  • Save after arranging the view. Saving the workbook helps preserve your worksheet view for later use, although how a view appears can depend on the Excel app and workbook window. If coworkers open the file in another app, ask them to confirm the freeze is visible as expected.

Troubleshooting

  • The wrong rows or columns are frozen: Choose View > Freeze Panes > Unfreeze Panes. Click the correct boundary cell and apply Freeze Panes again. For example, select C4 to freeze rows 1–3 and columns A–B. Check the selection before choosing the command; Excel does not ask you to confirm the number of rows or columns.
  • The Freeze Panes command is unavailable or behaves unexpectedly: Confirm that you are in a worksheet and not editing a cell. Press Enter or Esc to finish editing, then check the View tab again. If the workbook is protected or opened in a restricted mode, some editing actions may be limited; check the workbook’s protection status or ask its owner for access.
  • You cannot see the frozen boundary clearly: The divider can be subtle, especially with gridlines, borders, or a busy sheet. Scroll a little in both directions to see which area stays still. You can also temporarily zoom in or adjust the window size to make the boundary easier to identify.
  • Only row 1 or column A stays fixed: You likely used Freeze Top Row or Freeze First Column. Unfreeze first, then use a cell selection and the general Freeze Panes command to lock a different row or column range.
  • The sheet scrolls in an unexpected area: Check whether Split is turned on, or whether the worksheet has been scrolled away from its top-left corner before you apply a one-click freeze option. Use View > Split to turn off an active split, then return to the desired starting position and set the freeze again.
  • You are using Mac or Excel for the web: In Excel for Mac, use the View tab and its Freeze Panes menu; the exact ribbon layout can vary slightly by release. In Excel for the web, use View > Freeze Panes. If a command is not visible in a compact ribbon, expand the ribbon or widen the app window. The core rule is the same: select the cell below and to the right of the area to keep visible.

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. Selecting C3, for example, freezes rows 1–2 and columns A–B.

Can I freeze a row other than the top row?

Yes. To freeze through row 5, select a cell in row 6, such as A6, and use the general Freeze Panes command. It keeps all rows above the selection visible, not just row 5 by itself. Freeze Top Row always applies to row 1.

Can I freeze the first two columns?

Yes. Select a cell in column C, such as C1, and choose View > Freeze Panes > Freeze Panes. Columns A and B remain visible. Freeze First Column, by contrast, locks only column A.

Why does Excel freeze blank rows or columns too?

Freeze Panes works by position. Every row above and every column to the left of your selected cell is included, whether it contains data or is blank. Choose the boundary cell carefully, or remove unnecessary blank rows or columns if they are part of the layout.

Does freezing panes affect printing or other people opening the workbook?

Freezing is a screen-view setting, not a print setting, so it does not automatically repeat headings on paper. Use Page Layout > Print Titles for printed pages. The saved view may be available when the workbook is reopened, but another Excel app or window may display it differently, so check the workbook in the app your team uses.

How do I freeze more than one nonadjacent row or column?

You cannot use Freeze Panes to hold nonadjacent rows or columns independently. It freezes one continuous area from the top and left edges. Consider repeating labels in the data, using a table, or rearranging the worksheet so the key information sits together.

Related

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.