How To Freeze Rows And Columns In Excel (2026)

When you scroll down a long Excel sheet, your column labels disappear unless you lock them in place.

Freeze Panes keeps the rows above and the columns to the left of a cell you pick in view while the rest of the sheet scrolls.

The steps below follow Microsoft’s support pages, including how to unfreeze and what to do when the command is greyed out.

Quick answer: freeze and unfreeze

What you wantSelect this firstThen go to
Lock the top rowCell A2 (the first cell in row 2)View > Freeze Panes > Freeze Panes
Lock the first columnCell B1View > Freeze Panes > Freeze Panes
Lock the first two columnsThe third columnView > Freeze Panes > Freeze Panes
Lock several rows and columnsThe cell just below and just right of themView > Freeze Panes > Freeze Panes
Unlock everythingAny cellView > Freeze Panes > Unfreeze Panes

How Freeze Panes decides what to lock

Microsoft’s rule is that Freeze Panes locks the rows above and the columns to the left of the cell you select.

So the cell you click before using the command is what controls the result, not the cell you are looking at afterwards.

The top-row and first-column rows in the table above follow from that rule.

Freeze several rows and columns

  1. Select the cell just below the rows you want to keep visible, and just to the right of the columns you want to keep visible.
  2. Go to the View tab.
  3. Select Freeze Panes, then select Freeze Panes again in the list.

Microsoft’s Mac page gives an example: select D5 to freeze the top four rows and the leftmost three columns.

Freeze the first two columns

  1. Select the third column.
  2. Go to View > Freeze Panes > Freeze Panes.

Columns A and B then stay on screen while you scroll sideways.

Use the Freeze Top Row and Freeze First Column buttons

Microsoft’s Excel for Mac page lists two shortcuts on the View tab, Freeze Top Row and Freeze First Column.

It says a slightly darker border appears under row 1, or to the right of column A, once the freeze is on.

Microsoft’s iPad and iPhone page also says the View > Freeze Panes menu includes options for locking just the top row or the first column.

If you do not see those buttons in your version of Excel, use the selected-cell method from the table above, which follows Microsoft’s rule for the Freeze Panes command.

Unfreeze rows or columns

Go to the View tab, select Freeze Panes and choose Unfreeze Panes.

Microsoft’s iPad and iPhone page words this step differently, as it tells you to clear the selected options under Freeze Panes.

If Freeze Panes is greyed out or missing

Possible reasonWhat Microsoft says
You are in Page Layout viewPage Layout view is not compatible with Freeze Panes, so switch away from it
You are not in Normal view (Mac)Select Normal on the View tab first
No View tabYou may be using Excel Starter, which does not support every feature

Microsoft says to select Normal on the View tab if the Freeze buttons are greyed out.

Freeze panes on an iPad or iPhone

Microsoft’s page for Excel on iOS gives separate steps for each device.

DeviceSteps
iPadSelect the row below the last row to lock, or the column to the right of the last column to lock, then tap View > Freeze Panes > Freeze Panes
iPhoneSelect the row or column, tap the ellipses (…) button to open the ribbon, tap Home, then View, then scroll down and tap Freeze Panes
Unfreeze on eitherTap View > Freeze Panes and clear all the selected options

Microsoft adds that freezing columns starts from column A.

If row 1 or column A is hidden

A frozen top row is no use if row 1 itself is hidden.

Microsoft’s steps to unhide it are to select A1, either by typing A1 in the Name Box and pressing Enter or by using Home > Find & Select > Go To.

Then go to Home > Cells > Format, and under Visibility select Hide & Unhide and choose Unhide Rows or Unhide Columns.

Microsoft warns against selecting the whole worksheet and unhiding everything, because that reveals every hidden row and column.

Freeze Panes or Split: which to use

Split divides the sheet into panes you can scroll separately, which suits comparing two regions of a long sheet.

TaskSteps
Split rowsSelect the row below the split, then View > Window > Split
Split columnsSelect the column to the right of the split, then View > Window > Split
Split bothSelect the cell below and to the right of the split, then View > Window > Split
Remove a splitSelect View > Window > Split again

Microsoft’s example splits a results sheet below row 12 so the top finishers stay visible while you scroll to row 180.

Freezing does not affect printing

A frozen row stays on screen only, and it does not repeat on printed pages.

To repeat labels on paper, use our guide to repeating header rows on every printed page in Excel.

To squeeze a wide sheet onto fewer pages, see how to fit an Excel sheet on one page.

Which Excel versions this covers

Microsoft’s main freeze page lists the versions below.

VersionListed by Microsoft
Excel for Microsoft 365Yes
Excel for the webYes
Excel 2024, 2021, 2019 and 2016Yes
Excel for iPhoneYes

If a workbook hangs while you work in it, see fixing Excel not responding or freezing.

If you lose a sheet, recovering an unsaved Excel workbook explains AutoRecover.

Sources

Microsoft Support: Freeze panes to lock rows and columns.

Microsoft Support: Unfreeze locked panes.

Microsoft Support: Split panes to lock rows or columns in separate worksheet areas.

Microsoft Support: Freeze panes to lock the first row or column in Excel for Mac.

Microsoft Support: Freeze panes to lock the first row or column in Excel for iOS.

Microsoft Support: Unhide the first column or row in a worksheet.

Leave a Reply

Your email address will not be published. Required fields are marked *