When a worksheet has hundreds of rows, the column headings scroll out of view and you forget which column is which. Freeze Panes solves this by keeping chosen rows and columns on screen while the rest of the sheet scrolls. It takes only a few clicks and makes large tables far easier to read, check and edit. This guide shows how to freeze the top row, the first column, several rows and columns together, how to unfreeze, the keyboard shortcut, how freezing differs from splitting, how to print the headings on every page, and what to do when Freeze Panes is greyed out or does not behave as expected.
Updated November 2026
In this guide
- What Freeze Panes does
- Freeze the top row
- Freeze the first column
- Freeze several rows and columns
- Unfreeze panes
- The keyboard shortcut
- Freeze panes vs split panes
- Print the headings on every page
- Freeze panes in an Excel table
- Why Freeze Panes is greyed out or not working
- Freeze panes on a phone or tablet
- Good freeze settings for common sheets
- Practice exercise
- Common mistakes
What Freeze Panes does
Freeze Panes locks the rows above and the columns to the left of the selected cell so that they stay visible when you scroll. A thin line shows the boundary. Everything above and to the left of the line stays in place, and everything else scrolls normally. Freezing affects only what you see on screen. It does not change the data, the printout or the formulas. It is saved with the workbook, so the next person who opens the file sees the same frozen view.
Freeze the top row
This is the most common use. Go to the View tab, click Freeze Panes, and choose Freeze Top Row. The first row of the sheet stays visible while you scroll down. It works when your headings are in row 1. If the headings are lower, for example in row 3 below a title, use the next method instead, because Freeze Top Row always freezes row 1 only.
Freeze the first column
Go to View, Freeze Panes, and choose Freeze First Column. Column A stays visible when you scroll to the right. This is helpful for wide tables where column A holds names or IDs, such as a monthly report with twelve columns of figures, since you can always see which row you are reading. If your identifiers sit in columns A and B, use the custom method below to freeze both.
Freeze several rows and columns
To freeze a custom area, click the cell just below the rows and just to the right of the columns you want to keep. For example, to freeze rows 1 to 3 and columns A and B, click cell C4. Then go to View, Freeze Panes, and choose Freeze Panes at the top of the list. Everything above row 4 and left of column C is now frozen. To freeze only rows, click a cell in column A, such as A4, which freezes rows 1 to 3. To freeze only columns, click a cell in row 1, such as C1, which freezes columns A and B.
| You want to freeze | Click this cell first |
|---|---|
| Row 1 only | Use Freeze Top Row |
| Rows 1 to 3 | A4 |
| Column A only | Use Freeze First Column |
| Columns A and B | C1 |
| Rows 1 to 3 and columns A and B | C4 |
Unfreeze panes
To remove the freeze, go to View, Freeze Panes, and choose Unfreeze Panes. The same menu item shows Freeze Panes when nothing is frozen and Unfreeze Panes when something is. If you want to change the frozen area, unfreeze first, select the new cell and freeze again. Excel only keeps one frozen area per sheet, and each sheet in a workbook has its own setting.
The keyboard shortcut
On Windows, the ribbon key tips give you a keyboard route. Press Alt, then W, then F, and then F again to apply Freeze Panes at the selected cell. The same sequence unfreezes the panes when something is already frozen. To freeze only the top row, press Alt, W, F, then R. To freeze only the first column, press Alt, W, F, then C. These keys work one after another, not all together. On a Mac, use the View menu, because the key tips are different. Learning the sequence saves time when you build many sheets for clients, since you can set the view without leaving the keyboard.
Freeze panes vs split panes
Split divides the window into two or four scrollable areas, each of which can show a different part of the same sheet. Freeze locks part of the sheet in place. Use Split on the View tab when you want to compare two distant sections of a long sheet, such as the top and the totals at row 500. Use Freeze for headings. If you see a thick split bar and the sheet scrolls in sections, click Split again to turn it off. Freeze and Split are not used together, because freezing replaces the split.
Print the headings on every page
Freeze Panes does not affect the printout. To repeat the header rows on each printed page, go to Page Layout, click Print Titles, and in Rows to repeat at top enter the row, such as $1:$1. For columns, use Columns to repeat at left, such as $A:$A. Check the result in Print Preview. This is essential for long reports that go to a client as a PDF, since pages after the first would otherwise have no headings. Set this up together with the freeze, so the sheet is easy to read both on screen and on paper.
Freeze panes in an Excel table
When your data is in an Excel table, the column headings automatically replace the column letters at the top when you scroll down inside the table, as long as a cell in the table is selected. This works without Freeze Panes, but only while the active cell is in the table. If you have content above the table, or you want the headings to stay when you click elsewhere, use Freeze Panes as well. For tables with filters, such as the ones in our guide to the FILTER function, freezing the header row keeps the filter buttons in reach.
Why Freeze Panes is greyed out or not working
If the Freeze Panes button is greyed out, the sheet may be in Page Layout view or Page Break Preview. Switch to Normal view on the View tab. It can also be greyed out when a cell is being edited, so press Enter or Escape first. In a protected sheet, the command may be unavailable until you unprotect it. If you froze the wrong place, the active cell was not where you expected, so unfreeze and try again. If the frozen area takes up too much of the screen, on a small laptop or a phone you may not be able to scroll at all, so freeze fewer rows. Check also that the window is not too small to show the frozen area.
Freeze panes on a phone or tablet
In the Excel mobile app, open the file, tap the View tab or the more options menu, and choose Freeze Panes. You can then pick Freeze Top Row, Freeze First Column or Freeze Panes. On small screens, freeze as little as you can, since frozen rows and columns reduce the space for data. A good rule on mobile is to freeze only the header row. If a client mainly uses a phone, test the workbook on a phone before you deliver it, as a layout that looks fine on a large monitor can be unusable when the frozen area fills the screen.
Good freeze settings for common sheets
For an invoice list with a title in row 1 and headings in row 3, click A4 and freeze, so that the title and headings stay in view. For a wide monthly budget with the category names in column A and the months across the top, click B2 and freeze, so that both the month headings and the category names stay visible. For a customer database with an ID in column A and a name in column B, click C2 and freeze. For a dashboard with a small header band, freeze only the rows of that band, so charts are still free to scroll. Choosing the freeze point is a design decision, so think about which labels the reader needs to see at all times and freeze only those.
Practice exercise
Create a sheet with a title in row 1, headings in row 3 and 50 rows of data below. Try Freeze Top Row and notice that it freezes only the title. Unfreeze, click cell A4, and freeze again. Now the title, the blank row and the headings stay visible. Add a column of IDs in column A and freeze the first column too by clicking B4 and using Freeze Panes. Scroll in both directions to confirm that the headings and the IDs stay in view. Finally, set Print Titles to repeat row 3 on each page and check Print Preview. This takes about ten minutes and covers every case in this guide.
Common mistakes
The most common mistake is to select the wrong cell, which freezes the wrong area. Remember that Excel freezes above and to the left of the selected cell. Another is to freeze too many rows, so that only a small area remains to scroll. A third is to expect the freeze to apply to every sheet in the workbook, when each sheet needs its own setting. A fourth is to confuse freezing with hiding rows. A fifth is to forget Print Titles for the printout. Finally, if you share a template, test the frozen view on a smaller screen than your own.
Frequently asked questions
How do I freeze the top row in Excel?
Go to View, Freeze Panes, and choose Freeze Top Row.
How do I freeze both rows and columns?
Click the cell below and to the right of the area to freeze, then choose Freeze Panes.
How do I unfreeze panes?
Go to View, Freeze Panes, and choose Unfreeze Panes.
Why is Freeze Panes greyed out?
The sheet may be in Page Layout view, a cell may be in edit mode, or the sheet may be protected.
Does Freeze Panes affect printing?
No. Use Print Titles on the Page Layout tab to repeat headings on printed pages.


