No Ticket Needed

Appearance

4 min fix 3 min read Recently reviewedBeginner

By , IT support technician

Quick Answer

Click the row immediately below the rows you want to freeze, go to the View tab, click Freeze Panes, and select Freeze Panes from the dropdown.

How to Freeze Panes and Split Views in Excel ​

Applies to: Microsoft 365 (Excel desktop, Excel for the Web)
Article Type: How-To
Last Updated: 2026-03-09

Summary ​

When scrolling through large spreadsheets, your column headers and row labels disappear from view. Freeze Panes locks specific rows or columns in place so they stay visible while you scroll. This article covers freezing rows, columns, and using Split view.

Prerequisites ​

  • Microsoft Excel (desktop or web).

Instructions ​

1. Freeze the Top Row ​

Keep your header row visible while scrolling down.

  1. Open your spreadsheet in Excel.
  2. Go to the View tab.
  3. Click Freeze Panes > Freeze Top Row.
  4. A thin grey line appears below Row 1, indicating it is frozen.
  5. Scroll down — Row 1 stays visible.

2. Freeze the First Column ​

Keep the first column visible while scrolling right.

  1. Go to the View tab.
  2. Click Freeze Panes > Freeze First Column.
  3. A thin grey line appears to the right of Column A.

3. Freeze Multiple Rows and Columns ​

Lock any number of rows and columns at once.

  1. Click the cell below the rows and to the right of the columns you want to freeze.
    • Example: To freeze Row 1 and Column A, click cell B2.
    • Example: To freeze Rows 1–3 and Columns A–B, click cell C4.
  2. Go to the View tab.
  3. Click Freeze Panes > Freeze Panes.
  4. Grey lines appear showing the frozen boundary.

4. Unfreeze Panes ​

Remove all frozen rows and columns.

  1. Go to the View tab.
  2. Click Freeze Panes > Unfreeze Panes.
  3. All panes return to normal scrolling.

5. Use Split View ​

Split the window into independent scrollable panes (without freezing).

  1. Click the cell where you want the split to occur.
  2. Go to the View tab.
  3. Click Split.
  4. Four panes appear — each scrolls independently.
  5. Click Split again to remove it.

Troubleshooting ​

TIP

If you freeze panes and your headers still disappear, check that you clicked the correct cell before freezing. The freeze applies above and to the left of the selected cell.

Symptom / ErrorPotential CauseSolution
Headers disappear when scrollingPanes not frozenFollow the steps above to freeze the top row or multiple rows.
Wrong rows or columns are frozenSelected the wrong cell before freezingClick Freeze Panes > Unfreeze Panes, then reselect the correct cell and freeze again.
"Freeze Panes" is greyed outCurrently editing a cellPress Enter or Esc to exit edit mode, then try again.