Excel Freeze Panes: Keep Rows and Columns Visible

How-to basics · Updated November 3, 2026

To freeze panes 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 visible, then choose View > Freeze Panes > Freeze Panes. For a quick preset, choose View > Freeze Panes > Freeze Top Row or Freeze First Column.

What Freeze Panes Does

Freeze Panes keeps selected worksheet rows or columns on screen while you scroll through the rest of the sheet. It is especially useful when a large list extends beyond the window: you can keep column labels, dates, product names, or other identifying information visible as you move down or across the data.

The feature changes the worksheet view, not the data itself. It does not lock cells against editing, protect formulas, or stop rows and columns from being moved or changed. It also does not change the printed pages. When you print a long worksheet and want its headings repeated on each page, use Page Layout > Print Titles instead.

Excel draws a boundary to show the frozen area. The cells above and to the left of that boundary stay in place; the remaining worksheet scrolls. A freeze setting applies to the active worksheet, so you can set up different panes on different sheets in the same workbook.

Freeze the Top Row or First Column

Excel provides two presets for common layouts. They do not depend on the currently selected cell:

  • Keep the first row visible: choose View > Freeze Panes > Freeze Top Row. This is useful when row 1 contains field names such as Date, Customer, and Amount.
  • Keep the first column visible: choose View > Freeze Panes > Freeze First Column. This can help when column A contains names or product descriptions and you need to scroll horizontally.

After applying either preset, scroll down or sideways to confirm the expected labels remain on screen. The first-row option freezes row 1, not whichever row happens to contain a heading. If your headers are lower down because the sheet has a title or notes above them, use a custom freeze point instead.

Freeze Several Rows or Columns

For a custom arrangement, Excel uses the selected cell to decide where the frozen area ends. It freezes all rows above the selected cell and all columns to its left. The selected cell itself remains in the scrolling area. This means you should click the first cell that you want to scroll, rather than the last cell you want to freeze.

  1. Click the worksheet cell immediately below the last row you want frozen and immediately to the right of the last column you want frozen.
  2. Choose View > Freeze Panes > Freeze Panes. Choose the first Freeze Panes command in the menu, not Freeze Top Row or Freeze First Column.
  3. Scroll down and across to check that the correct rows and columns stay visible.

For example, to keep rows 1 and 2 visible, click A3 before choosing Freeze Panes. To keep columns A and B visible, click C1. To keep both rows 1 and 2 and columns A and B visible, click C3. If you click D4, Excel freezes rows 1 through 3 and columns A through C. A frequent mistake is selecting the last header cell itself; because Excel freezes only the rows above and columns to the left of the selection, that can leave out a row or column you meant to keep.

Choose the Right Freeze Point

Start by identifying what information a reader needs in order to interpret the cells currently on screen. In a sales sheet, that might mean a heading row and a salesperson column. In a schedule, it could be several rows of dates and a column of employee names. Choose the smallest useful frozen area: freezing too many rows or columns leaves less room for the scrolling part of the sheet.

  • One header row: use Freeze Top Row when the labels are in row 1; otherwise select the cell below the actual header row and use the custom command.
  • Several header or context rows: select a cell in row 2 or lower, depending on how many upper rows should remain visible.
  • A row and an identifying column: select a cell below the needed rows and to the right of the needed columns. For row 1 and column A, select B2.
  • Only a left-hand label column: use Freeze First Column if the labels are in column A. For labels in another column, use a custom selection.

Consider the size of your Excel window as well. If the frozen section takes up most of the visible area, there may be little room left to inspect the data. You can adjust the window size or choose a smaller freeze area if scrolling feels cramped.

Unfreeze or Change the Panes

To remove the current freeze setting, choose View > Freeze Panes > Unfreeze Panes. Excel returns the worksheet to normal scrolling. To change the boundary, unfreeze first, select the new cell, and apply Freeze Panes again. Choosing one of the presets also changes the current arrangement to that preset, so it is best to unfreeze before setting up a different custom combination.

Freeze Panes is not a toggle that simply moves the boundary each time you click it. If an unexpected line remains, open the menu and check whether Unfreeze Panes is available. Unfreeze the existing setting before trying another selection. The change affects the view, so it does not erase cell contents or formulas.

Common Problems and Misunderstandings

  • The wrong row or column stays visible: unfreeze and select the cell one row below and one column to the right of the area you want held in place. Remember that custom freezing works above and left of the selected cell.
  • The top-row preset freezes the wrong heading: Freeze Top Row always means worksheet row 1. Use a custom freeze point if your table headings begin farther down.
  • Only one of two desired areas is frozen: the Top Row and First Column presets are single-purpose settings. To freeze both, select the cell below the target rows and right of the target columns, then use the main Freeze Panes command.
  • The feature appears unavailable: make sure you are not actively editing a cell. Press Enter or Esc to finish or cancel the edit, then try the View menu again. If the workbook is protected or opened in a restricted state, some commands may also be unavailable.
  • The frozen lines seem missing: look for the boundary near the selected row or column, then scroll to test the behavior. A narrow window or unusual zoom level can make the frozen region less obvious.

Frozen panes can make navigation easier, but they do not create a permanent header in a printed report. They also do not prevent someone from editing the frozen cells. Use worksheet protection for editing restrictions and Print Titles for repeated printed headings; those features solve different problems.

Freeze Panes Compared with Split

Freeze Panes and Split can both divide the worksheet window, but they behave differently. Freeze Panes holds specific rows at the top and columns at the left while the rest of the sheet scrolls. Split divides the window into separate panes that can be scrolled independently. Split can be useful for comparing distant parts of one worksheet, while Freeze Panes is generally better for keeping labels visible as you inspect a long table.

For example, if you need to compare a row near the top with another far down the sheet, a split view may help because the panes can show different worksheet locations. If your main need is to keep row 1 and column A visible as you browse the data, use Freeze Panes. Avoid applying both until you understand the resulting view; if the worksheet is already split, remove or adjust that split before troubleshooting a freeze setting.

Excel on Mac and in a Browser

In Excel for Microsoft 365 on Mac, the same selection logic applies. Use the View tab or View menu and choose Freeze Panes, then select the appropriate option; menu presentation can vary slightly with the Excel interface. Mac keyboard shortcuts differ from Windows, and there is no need to use a shortcut for this task.

In Excel for the web, open the View tab and use its Freeze Panes controls. The available commands and layout may differ slightly from the Windows desktop ribbon, but the basic choices are similar. If a workbook is open in a browser and a command is missing or behaves differently, opening it in the desktop app can provide the full desktop ribbon and its options.

Frequently Asked Questions

How do I freeze the first two rows in Excel?
Select A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible while the lower rows scroll.

How do I freeze the top row and first column at the same time?
Select B2, then choose View > Freeze Panes > Freeze Panes. The custom command freezes the row above and the column to the left, keeping row 1 and column A in view.

Can I freeze rows that are not at the top?
Freeze Panes holds rows above the selected cell, not an isolated row in the middle of the worksheet. For example, selecting A6 freezes rows 1 through 5; it cannot freeze only row 5 while allowing rows 1 through 4 to scroll.

Does freezing panes affect printing?
No. Freeze Panes controls the on-screen worksheet view. To repeat heading rows on printed pages, go to Page Layout > Print Titles and set the rows to repeat at the top.

How do I remove frozen panes in Excel?
Choose View > Freeze Panes > Unfreeze Panes. You can then leave the sheet unfrozen or select a new cell and apply a different freeze arrangement.

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.