Home / Tech
Tech

How to Freeze Panes in Excel: Rows, Columns and Both

Illustration for How to Freeze Panes in Excel: Rows, Columns and Both

If you have ever scrolled down a long spreadsheet and lost track of which column is which, it helps to know how to freeze panes in Excel. Freezing panes keeps the rows or columns you choose visible while the rest of the sheet scrolls, so your headings never disappear. This guide covers freezing the top row, the first column, both together and a custom block, plus how to unfreeze, what to do when the buttons are greyed out and how to keep headings when you print.

Illustration showing the main idea of How to Freeze Panes in Excel: Rows, Columns and Both

What does freeze panes do in Excel?

According to Microsoft’s support pages, Freeze Panes locks rows, columns or both to the top and left of a sheet. Everything above and to the left of the cell you select stays on screen as you scroll. A faint line appears between the frozen area and the scrolling area to show where the freeze sits. It changes only what you see on screen. Your data and formulas are not affected.

How to freeze the top row in Excel

  1. Open the worksheet you want to work on.
  2. Go to the View tab.
  3. Select Freeze Panes, then choose Freeze Top Row.

Scroll down and row 1 stays in place. This is the quickest option for a table with a single row of headings.

How to freeze the first column in Excel

  1. Go to the View tab.
  2. Select Freeze Panes, then choose Freeze First Column.

A faint line between columns A and B shows that the first column is frozen. Scroll to the right and column A stays visible, which is handy when each row starts with a name or reference number.

How to freeze rows and columns together

To keep both the top row and the first column visible, select cell B2, then go to View, Freeze Panes and choose Freeze Panes. To freeze a larger block, select the cell just below the last row and just to the right of the last column you want to keep. Excel freezes everything above and to the left of that cell. For example, selecting D5 freezes the top four rows and the leftmost three columns.

What you want to freeze Select this first Command on the View tab
Top row only Any cell Freeze Panes, then Freeze Top Row
First column only Any cell Freeze Panes, then Freeze First Column
Top row and first column Cell B2 Freeze Panes, then Freeze Panes
First two rows only Cell A3 Freeze Panes, then Freeze Panes
Top four rows and three left columns Cell D5 Freeze Panes, then Freeze Panes

Microsoft notes that you can freeze as many rows or columns as you like, as long as the frozen block starts from the top row or the first column.

Keyboard shortcut for freeze panes

On Windows, a commonly used shortcut sequence is Alt, then W, then F, then F, which opens View, Freeze Panes, Freeze Panes. Press the keys one after another rather than all at once. Our guide to Excel keyboard shortcuts covers more time savers like this.

How to unfreeze panes in Excel

Go to the View tab, select Freeze Panes and choose Unfreeze Panes. Once the panes are unfrozen, the same menu offers the freeze options again, so you can set a new freeze position.

Freeze panes greyed out or not working?

  • Check the view: the Freeze Panes buttons can be greyed out in Page Layout view or while you are typing in a cell. Press Esc to leave the cell, then select Normal on the View tab.
  • The frozen area is too big: if you freeze too many rows or columns there may be little or no room left to scroll. Unfreeze and choose a smaller block.
  • You froze the wrong place: the freeze follows the cell you selected, so unfreeze, select the correct cell and freeze again.
  • You cannot find the View tab: Microsoft notes that Excel Starter does not show the View tab and does not support every feature.
Checklist-style illustration for How to Freeze Panes in Excel: Rows, Columns and Both

Freeze panes versus split panes

Freezing locks chosen rows or columns in place. Splitting panes divides the window into separate areas of the same worksheet that each scroll independently, which is useful when you want to compare two distant parts of a large sheet. Microsoft documents split panes separately, so use freeze for headings and split for comparing sections.

Keep headings visible when you print

Freeze panes affects only what you see on screen. To repeat your headings on every printed page, go to Page Layout, select Print Titles and enter the row you want in Rows to repeat at top.

Keep your data clean with our guide to removing duplicates in Excel, or make data entry faster by learning how to create a drop down list in Excel.

Frequently asked questions

How do I freeze the top row in Excel?

Go to the View tab, select Freeze Panes and choose Freeze Top Row. Row 1 will stay visible as you scroll down.

How do I freeze the first two rows?

Select cell A3, the cell below the rows you want to keep, then go to View, Freeze Panes and choose Freeze Panes.

How do I freeze rows and columns at the same time?

Select the cell below and to the right of the area you want to freeze, for example B2 for the top row and first column, then choose View, Freeze Panes, Freeze Panes.

Why is freeze panes greyed out?

You may be in Page Layout view or editing a cell. Press Esc, switch to Normal view on the View tab and try again. Excel Starter does not show the View tab.

Does freezing panes affect printing?

No. Freeze panes only changes the on-screen view. Use Print Titles on the Page Layout tab to repeat rows at the top of every printed page.

Can I freeze panes in Excel for the web or on a Mac?

Yes. Microsoft documents freeze panes for Excel for the web and Excel for Mac, although menu layouts can differ slightly from the Windows version.