How to Freeze Panes in Excel in 7 Simple Steps and Avoid Costly Mistakes

Learning how to freeze panes in excel takes about two minutes. Freeze Panes locks chosen rows and columns in place, so your headers stay visible while the rest of the sheet moves. This guide gives you the seven steps in order, covers Windows and Mac, and lists the mistakes that waste your time.

Microsoft Excel is the spreadsheet editor from Microsoft, and it is part of Microsoft 365 and Microsoft Office. Excel first appeared for the Apple Macintosh on September 30, 1985, and the first Windows version followed on November 19, 1987. Microsoft reported 80.8 million Microsoft 365 Consumer subscribers in April 2024, and one worksheet can hold up to 1,048,576 rows by 16,384 columns.

To freeze panes in Excel, select the cell below the rows and to the right of the columns you want to keep visible. Go to the View tab, click Freeze Panes, and choose Freeze Panes. The rows above and the columns to the left of your selected cell stay on screen while you scroll.

ANSWER BOX 1

To freeze panes in Excel, click the cell just below the rows and just to the right of the columns you want to lock. Go to the View tab, click Freeze Panes, and choose Freeze Panes. A dark line marks the frozen edge. Scroll down or right, and your headers stay visible while the data moves.

ANSWER BOX 2

Freeze Panes is a view setting, not a change to your data. It locks rows and columns on screen only, and it never hides, moves, or deletes any cell. Turn it off at any time from View, then Freeze Panes, then Unfreeze Panes. One freeze works per sheet, so pick the rows and columns that matter most.

KEY TAKEAWAYS

  • How to freeze panes in excel starts with one rule: pick the cell below and to the right of what you want to lock.
  • The path is View, then Freeze Panes, then Freeze Panes, on Windows and on Mac.
  • Freeze Top Row locks row 1 only, and Freeze First Column locks column A only.
  • Freeze Panes does nothing for printing, so use Print Titles to repeat headers on paper.
  • You must unfreeze before you freeze a new area, because one freeze works per sheet.

Contents

  • What does Freeze Panes mean in Excel?
  • How to freeze panes in Excel in 7 simple steps
  • How to freeze the top row and first column
  • How to freeze panes in Excel on a Mac
  • How to freeze panes in Excel for the web
  • How to freeze panes for printing
  • Freeze Panes vs Split Panes
  • 7 mistakes to avoid when you freeze panes in Excel
  • A real-world workflow: freeze panes for a monthly budget
  • What to do after you freeze panes in Excel
  • FAQ

What Does Freeze Panes Mean in Excel?

Freeze Panes is a view command in Microsoft Excel that keeps chosen rows and columns fixed while you scroll through a worksheet. The frozen rows stay at the top of the window, and the frozen columns stay at the left edge of the window. The rest of the sheet moves as normal under them.

This matters because a worksheet can grow very long, and headers are the only clue to what each number means. A sales sheet with Date, Product, Units, and Total in row 1 is clear at the top, but by row 200 those labels are far out of sight. Without a freeze, you scroll up to check a header, then scroll down again to find your place.

The rule behind the command is simple, and Microsoft Support states it in one clear line. Freeze Panes freezes the rows above the selected cell and the columns to the left of the selected cell. The cell you click decides everything, so the whole skill is really about picking the right cell before you open the menu.

How to Freeze Panes in Excel in 7 Simple Steps

These seven steps cover Microsoft Excel on Windows. Work through the steps in order, and check your result by scrolling before you move on.

  1. Open your workbook in Excel and click the sheet you want to fix. Make sure your headers sit in the top rows and your labels sit in the left columns, so the freeze has something clear to hold.
  2. Press Ctrl plus Home to jump to cell A1. This puts the top left of your sheet at the top left of the window, so row 1 is the first row you can see.
  3. Click the cell below the rows and to the right of the columns you want to keep. For a header in row 1 and names in column A, click B2. For two header rows and one label column, click B3.
  4. Go to the View tab on the ribbon at the top of Excel. The View tab holds the Window group, and the Freeze Panes button sits in that group.
  5. Click Freeze Panes to open its menu. The menu shows three choices: Freeze Panes, Freeze Top Row, and Freeze First Column. The first choice is the general command, while the other two are quick presets.
  6. Choose Freeze Panes from the menu. Excel draws a thin dark line under the frozen rows and to the right of the frozen columns. That line is your proof that the freeze is active.
  7. Scroll down and to the right to test the freeze. Your header rows should stay at the top, and your label column should stay at the left, while the rest of the data moves.

If the wrong rows stay fixed, unfreeze and pick a new cell, then repeat the steps. A wrong freeze is easy to fix, so do not worry if your first try locks the wrong rows.

Hands on a keyboard while learning how to freeze panes in Excel

How to Freeze the Top Row and First Column

The Freeze Panes menu holds two presets that cover the two most common needs, and both are faster than the general method. Freeze Top Row keeps row 1 on screen while you scroll down, and it ignores which cell you selected. Freeze First Column keeps column A on screen while you scroll right, and it also ignores your selection. Use a preset when it matches your need exactly, and use the general command when it does not.

To freeze only the top row, press Ctrl plus Home first so row 1 is at the top of the view. Then go to View, click Freeze Panes, and choose Freeze Top Row. Scroll down, and row 1 will stay fixed at the top. Our guide on how to freeze top row in excel covers this preset step by step, with examples for sales lists and class lists.

To freeze only the first column, press Ctrl plus Home first so column A is at the left edge of the view. Then go to View, click Freeze Panes, and choose Freeze First Column. Scroll right through your sheet, and column A will stay fixed at the left while the columns to its right move. Our guide on how to freeze first column in excel covers this preset in full, with examples for wide monthly reports.

What should stay visible?Cell to select firstMenu choice
Top header row onlyAny cellView, Freeze Panes, Freeze Top Row
First column onlyAny cellView, Freeze Panes, Freeze First Column
Header row and first columnB2View, Freeze Panes, Freeze Panes
Two header rows and first columnB3View, Freeze Panes, Freeze Panes
Two header rows and two label columnsC3View, Freeze Panes, Freeze Panes
Nothing frozenAny cellView, Freeze Panes, Unfreeze Panes

How to Freeze Panes in Excel on a Mac

Open your workbook in Excel for Mac and click the sheet you want to fix. Press Control plus Home, or use Fn plus Control plus Left Arrow on a laptop keyboard, to jump to cell A1. Click the cell below the rows and to the right of the columns you want to keep, such as B2 for one header row and one label column. Then go to the View tab, click Freeze Panes, and choose Freeze Panes, Freeze Top Row, or Freeze First Column. The Mac menu lists the same three choices as Windows, and Unfreeze Panes appears in the same menu once a freeze is active. Scroll to test the freeze, and look for the thin dark line under the frozen rows and to the right of the frozen columns.

How to Freeze Panes in Excel for the Web

Excel for the web is the free browser version of Microsoft Excel, and it also offers Freeze Panes with shorter menu names. Your freeze is saved with the file, so it will still be there in the desktop app. Open the workbook in Excel for the web and click the sheet you want to fix. Select the cell below the rows and to the right of the columns you want to keep, such as B2 for one header row and one label column. Go to the View tab, click Freeze Panes, and choose Top Row, First Column, or Freeze at selection. Top Row and First Column are the presets, and Freeze at selection is the general command for a custom area.

How to Freeze Panes for Printing

Here is the gap most guides skip, and it catches many users by surprise. Freeze Panes works on screen only, and it does nothing for printing, so your headers will still vanish on page two of a printout. The screen freeze and the print repeat are two separate settings in Excel, and you need both if you want headers on screen and on paper.

To repeat headers on every printed page, go to the Page Layout tab and click Print Titles in the Page Setup group. In the dialog box, click in the Rows to repeat at top box, then click the header rows on your sheet, such as row 1, or rows 1 to 2 for a two row header. If you also want a label column on every printed page, click in the Columns to repeat at left box, then click column A on your sheet. Click OK to save the setting. Check the result in Print Preview before you print. Press Ctrl plus P, and look at page two and page three to confirm the headers repeat.

Freeze Panes vs Split Panes

Freeze Panes and Split Panes look alike at first, because both divide the window, but they solve different problems. Freeze Panes locks one area in place while the rest scrolls, so you always see the same headers. Split Panes divides the window into two or four separate panes, and each pane scrolls on its own, so you can compare two distant areas.

Use Freeze Panes when your need is simple and constant, such as keeping headers visible while you scroll a long list. Use Split when you need to compare two distant areas at the same time. Split is the better tool for a one off check, while Freeze is the better tool for daily work.

FeatureFreeze PanesSplit Panes
What it doesLocks rows and columns in placeDivides the window into separate panes
ScrollingFrozen area stays still, rest scrollsEach pane scrolls on its own
Best forHeaders on a long listComparing two distant areas
Number of areasOne fixed edge plus one scrolling areaTwo or four panes
How to remove itView, Freeze Panes, Unfreeze PanesView, Split, or drag the split bar away
Changes your dataNo, view onlyNo, view only

7 Mistakes to Avoid When You Freeze Panes in Excel

These seven mistakes cost new Excel users the most time, and every one of them is easy to avoid. Read the list before you set your next freeze.

  1. Selecting the wrong cell before you freeze. Freeze Panes locks the rows above and the columns to the left of the selected cell, so one row off means the wrong header stays fixed. Click the cell just below the last row and just to the right of the last column you want to keep.
  2. Freezing while the sheet is scrolled down. If row 1 is not at the top of the view, the freeze can lock rows you did not mean to lock. Press Ctrl plus Home first, check that row 1 is visible.
  3. Trying to freeze a second area without unfreezing first. Excel allows only one freeze per sheet, so a new freeze will replace the old one or fail to apply cleanly. Go to View, then Freeze Panes, then Unfreeze Panes first.
  4. Expecting the freeze to work on a printout. Freeze Panes is a screen setting only, and it never repeats headers on paper. Use Page Layout, then Print Titles, and pick Rows to repeat at top if you want headers on every printed page.
  5. Freezing in Page Layout view and wondering why the menu is greyed out. Freeze Panes does not work in Page Layout view, so switch back to Normal view from the View tab or the status bar, then try again.
  6. Freezing the wrong sheet in a workbook with many sheets. A freeze applies to one sheet only, so the sheet you see now is the sheet that gets frozen. Click the right sheet tab at the bottom first, then set the freeze.
  7. Forgetting to tell your team about the freeze in a shared file. A frozen header helps most readers, but a teammate who does not expect it may think the sheet is broken. Add one line in your message when you share the file.

If a freeze still fails, read our guide on freeze panes in excel not working for the fixes. Start with the greyed out menu and the wrong cell, because those two causes cover most failures.

A Real-World Workflow: Freeze Panes for a Monthly Budget

A monthly budget is the best place to see Freeze Panes earn its keep, because the sheet is long and the numbers only make sense with their labels. Picture a budget with months across the top in row 1, from January to December, and expense types down column A, from Rent to Groceries to Transport. Set the freeze before you start typing numbers, not after the sheet is full. Click cell B2, then go to View, click Freeze Panes, and choose Freeze Panes. Row 1 stays at the top, column A stays at the left, and every number you type after that stays tied to its month and its expense type.

A tidy desk with a laptop showing a data table for how to freeze panes in Excel

At the end of the month, set Print Titles as well, so the printed budget carries the same headers on every page. Print a preview, check page two, and then print or save the file as a PDF.

What to Do After You Freeze Panes in Excel

A freeze is a start, not a finish, so check it, save it, and use it in your daily work. Scroll down and right to confirm that the right rows and columns stay fixed. If the wrong area stays fixed, unfreeze and set it again from a new cell.

Save the workbook after you set the freeze, because the freeze is saved with the file. To change the freeze later, go to View, then Freeze Panes, then Unfreeze Panes, and set a new freeze from a fresh cell. Our guide on how to unfreeze panes in excel covers removal in full, with the cases where Unfreeze Panes does not appear and what to do next.

How to Freeze Panes in Excel FAQ

How do I freeze panes in Excel?

Select the cell below the rows and to the right of the columns you want to keep. Go to the View tab, click Freeze Panes, and choose Freeze Panes. The rows above and the columns to the left of your cell stay visible while you scroll.

How do I freeze only the top row in Excel?

Go to View, click Freeze Panes, and choose Freeze Top Row. Row 1 stays at the top while you scroll down, and your selection does not matter.

How do I freeze only the first column in Excel?

Go to View, click Freeze Panes, and choose Freeze First Column. Column A stays at the left while you scroll right, and your selection does not matter.

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

Click the cell just below the last row and just to the right of the last column you want to keep. For one header row and one label column, click B2. Then go to View, click Freeze Panes, and choose Freeze Panes to lock both at once.

How do I unfreeze panes in Excel?

Go to the View tab, click Freeze Panes, and choose Unfreeze Panes. The frozen rows and columns start to scroll again at once.

Why is Freeze Panes greyed out in Excel?

Freeze Panes is greyed out in Page Layout view, so switch back to Normal view first. It can also be blocked by a protected sheet or by an old file format.

Does Freeze Panes work on a Mac?

Yes, Excel for Mac has the same command on the View tab. Select your cell, go to View, click Freeze Panes, and choose Freeze Panes, Freeze Top Row, or Freeze First Column. The Mac menu matches the Windows menu, and Unfreeze Panes appears once a freeze is active.

Does Freeze Panes work in Excel for the web?

Yes, Excel for the web offers Freeze Panes on the View tab. The menu names are shorter: Top Row, First Column, and Freeze at selection.

Can I freeze more than one area in Excel?

No, Excel allows only one freeze per sheet. If you want a different area, unfreeze first, then pick a new cell and freeze again. Each sheet in a workbook can have its own freeze, so set each sheet separately.

Does Freeze Panes print the headers on every page?

No, Freeze Panes works on screen only, and it does nothing for printing. To repeat headers on paper, go to Page Layout, click Print Titles, and set Rows to repeat at top. Check the result in Print Preview before you print.

What is the difference between Freeze Panes and Split Panes?

Freeze Panes locks chosen rows and columns in place while the rest of the sheet scrolls. Split Panes divides the window into two or four panes that scroll on their own, so you can compare two distant areas. Use Freeze for daily work, and Split for a one off comparison.

Can I freeze panes in Google Sheets with these steps?

No, these steps are for Microsoft Excel only, and Google Sheets uses a different menu. Google Sheets has its own View, then Freeze command, with different names and limits. Do not mix the two apps, because the menu paths and the results are not the same.

Does freezing panes change or hide my data?

No, Freeze Panes never changes, hides, moves, or deletes any cell. It is a view setting only, and it changes what stays on screen while you scroll. You can still edit frozen cells, and you can remove the freeze at any time without losing data.

What keyboard shortcut freezes panes in Excel?

There is no single shortcut that freezes panes in one key press. On Windows, press Alt, then W, then F, then F to open the Freeze Panes menu, and pick your choice.

Final Word

Learning how to freeze panes in excel is a two minute job, and it pays off every time you open a long sheet. Pick the right cell first, press Ctrl plus Home so row 1 is in view, then go to View, click Freeze Panes, and choose Freeze Panes. Test it by scrolling, set Print Titles if the sheet will be printed, and save the file so the freeze stays with it. Start with the B2 freeze for a normal table, and use the presets when they match your need. Our guide on how to unfreeze panes in excel shows you how to remove the freeze cleanly.

Read more about Microsoft Excel on Wikipedia: https://en.wikipedia.org/wiki/Microsoft_Excel

Leave a Reply