Freezing rows and columns keeps your headers in place while you scroll

When you have a spreadsheet with many rows and columns, the header row (and sometimes the first few columns) scroll out of view as you move down or across. Freezing locks those rows or columns in place so they stay visible no matter where you scroll. Excel calls this feature "Freeze Panes," and it works the same way whether you're using Excel on Windows, Mac, or the web version.

The key to freezing correctly is understanding where you click before you freeze. Excel freezes everything above and to the left of your cursor position. So if you want to freeze the top row and the first three columns, you click on the cell where row 4 meets column D, then freeze from there.

Key Takeaways

  • Click on the cell directly below the rows you want to freeze and directly to the right of the columns you want to freeze before you freeze.
  • Use the View tab in Excel, then select Freeze Panes to lock rows and columns in place.
  • You can freeze only rows, only columns, or both rows and columns in the same spreadsheet.
  • To unfreeze, go back to the View tab and click Unfreeze Panes — this removes all freezing at once.

Freeze only the top row

The most common freezing task is locking the header row so it stays visible when you scroll down through data. Click on any cell in row 2 (the row directly below your headers). It does not matter which column you click — row 2, column A is the easiest choice.

Go to the View tab at the top of the ribbon. Look for the Freeze Panes button (it usually shows a small grid with lines through it). Click Freeze Panes. Now when you scroll down, row 1 stays at the top of your screen.

Freeze the top row and the first few columns

If your spreadsheet has row headers on the left side that you want to keep visible while scrolling right, you can freeze both rows and columns at the same time. The trick is clicking on the correct starting cell.

Count how many columns you want to freeze (for example, three columns: A, B, and C). Count how many rows you want to freeze (usually just one header row). Click on the cell where the first unfrozen row meets the first unfrozen column. If you want to freeze columns A through C and row 1, click on cell D2. Then go to View, find Freeze Panes, and click it. Now both your header row and your first three columns stay in place when you scroll.

Freeze multiple rows at the top

Some spreadsheets have more than one header row — perhaps a title row, then a column-name row below it. To freeze both, click on the first row you do not want frozen. If rows 1 and 2 are headers and you want both frozen, click on any cell in row 3.

Go to View and click Freeze Panes. Both rows 1 and 2 now stay visible when you scroll down. The same logic applies if you have three or four header rows — just click on the row number that comes right after your last header row.

Unfreeze rows and columns

To remove all freezing from your spreadsheet, go to the View tab and click Freeze Panes again. The button acts as a toggle — when panes are frozen, clicking it unfreezes them. Excel removes all frozen rows and columns at once; you cannot unfreeze just the rows while keeping the columns frozen.

If you want to change which rows or columns are frozen, unfreeze first, then click on the new cell position and freeze again.

Freeze panes in Excel Online

The web version of Excel works the same way. Click on the cell below and to the right of what you want to freeze. Go to the View tab (or look for a menu icon if you are on a mobile device), find Freeze Panes, and click it. The frozen rows and columns behave identically to the desktop version.

One difference: in Excel Online, the Freeze Panes button may be in a dropdown menu under View rather than visible as a single button. Look for "Freeze Panes" or "Freeze" in the View menu if you do not see it when ready.

What happens when you freeze panes

When rows or columns are frozen, Excel draws a slightly thicker line between the frozen and unfrozen areas. This line shows you exactly where the freeze boundary is. The frozen rows and columns do not scroll — they stay locked to the top and left edges of your screen. The unfrozen rows and columns scroll normally.

Freezing does not change your data or hide anything permanently. It only changes what you see on screen. If you print the spreadsheet, the frozen panes do not print as frozen — they print as a normal spreadsheet. If you share the file with someone else, the freezing setting travels with the file, so they will see the same frozen panes you set up.

Frequently Asked Questions

Can I freeze panes in the middle of my spreadsheet, not at the top?

Yes. Click on any cell, and everything above and to the left of that cell freezes. If you click on cell E15, rows 1 through 14 and columns A through D freeze. This is useful for comparing data in different parts of a large spreadsheet, though it is less common than freezing the top row.

What if I freeze panes but then add new rows at the top?

The freeze position stays where you set it. If you freeze at row 3 and then insert a new row at the top, your freeze is now at row 4. You may need to unfreeze and refreeze at the correct position if the new rows change your layout.

Does freezing panes work the same way on Mac?

Yes. The steps are identical on Excel for Mac. Click on the cell below and to the right of what you want to freeze, go to View, and click Freeze Panes. The button location and behavior are the same as on Windows.

Can I freeze panes and then print only the unfrozen section?

Freezing does not affect printing. When you print, the entire spreadsheet prints normally without any frozen boundaries. If you want to print only part of your spreadsheet, use the print area feature instead of relying on frozen panes.