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 want | Select this first | Then go to |
|---|---|---|
| Lock the top row | Cell A2 (the first cell in row 2) | View > Freeze Panes > Freeze Panes |
| Lock the first column | Cell B1 | View > Freeze Panes > Freeze Panes |
| Lock the first two columns | The third column | View > Freeze Panes > Freeze Panes |
| Lock several rows and columns | The cell just below and just right of them | View > Freeze Panes > Freeze Panes |
| Unlock everything | Any cell | View > 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
- 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.
- Go to the View tab.
- 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
- Select the third column.
- 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 reason | What Microsoft says |
|---|---|
| You are in Page Layout view | Page 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 tab | You 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.
| Device | Steps |
|---|---|
| iPad | Select 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 |
| iPhone | Select 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 either | Tap 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.
| Task | Steps |
|---|---|
| Split rows | Select the row below the split, then View > Window > Split |
| Split columns | Select the column to the right of the split, then View > Window > Split |
| Split both | Select the cell below and to the right of the split, then View > Window > Split |
| Remove a split | Select 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.
| Version | Listed by Microsoft |
|---|---|
| Excel for Microsoft 365 | Yes |
| Excel for the web | Yes |
| Excel 2024, 2021, 2019 and 2016 | Yes |
| Excel for iPhone | Yes |
Related Excel fixes
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.