How to Freeze Panes in Excel

To freeze panes in Excel, go to the View tab, click Freeze Panes, and choose Freeze Top Row, Freeze First Column, or Freeze Panes. Freeze Top Row keeps your header row visible as you scroll down. To lock several rows or columns, select the cell just below and to the right of them first, then choose Freeze Panes.

These steps work in Excel for Microsoft 365, Excel 2024, 2021, 2019, and 2016 on Windows. Excel for Mac, Excel for the web, and the iPhone, iPad, and Android apps use the same View tab commands with small layout differences, covered in their own section below.

Freezing only changes what you see on screen. It doesn’t move, lock, or change your data, and it doesn’t affect printing.

Pick the Right Freeze Option

What you want to keep on screen Select this first Then choose
Row 1 only Any cell Freeze Top Row
Column A only Any cell Freeze First Column
Rows 1 to 3 Cell A4 (or all of row 4) Freeze Panes
Columns A and B Cell C1 (or all of column C) Freeze Panes
Row 1 and column A Cell B2 Freeze Panes
Rows 1 to 3 and columns A and B Cell C4 Freeze Panes

The rule behind the table: Freeze Panes keeps every row above and every column to the left of the cell you select.

How to Freeze the Top Row in Excel

  1. Open your worksheet and press Ctrl + Home so row 1 is showing at the top of the window.
  2. Click the View tab.
  3. Click Freeze Panes in the Window group. A menu with three options opens.
  4. Choose Freeze Top Row.

A thin line appears under row 1. When you scroll down, row 1 stays in place above the rest of the sheet. If row 1 holds a report title, you can make that header span multiple columns in Excel without merging any cells.

Excel worksheet with the top row frozen while scrolling, and the Freeze Panes menu open showing Unfreeze Panes
Screenshot of an Excel worksheet with the top row frozen and the Freeze Panes menu open.
Card showing View tab, Freeze Panes, Freeze Top Row, First Column or Panes in Excel
All three freeze options live under View > Freeze Panes.

Why step 1 matters: Excel freezes the rows that are on screen when you click the command. If you have scrolled down to row 40, the frozen area can start there instead of at your headers, and the rows above it are hard to reach. Going back to the top first avoids that.

How to Freeze the First Column

  1. Press Ctrl + Home so column A is showing on the left.
  2. Click the View tab.
  3. Click Freeze Panes.
  4. Choose Freeze First Column.

A thin vertical line appears to the right of column A. Column A now stays visible when you scroll to the right, which helps when names, dates, or IDs are in the first column. This is handy for an ID column, which you can fill with counting numbers before you freeze it.

Freeze Top Row and Freeze First Column each lock exactly one row or one column, and choosing one replaces the other. To keep both row 1 and column A on screen, use the Freeze Panes option with cell B2, as shown in the next section. To make a header row sortable as well as visible, see how to make sortable headings in Excel.

How to Freeze Multiple Rows or Columns

Microsoft’s freeze panes guide explains that Freeze Panes locks the rows above and the columns to the left of the cell you select. So the cell you click decides what stays put.

  1. Press Ctrl + Home to return to the top-left corner of the sheet.
  2. Click the cell below the last row and to the right of the last column you want to freeze. For example, click A4 to freeze rows 1 to 3, C1 to freeze columns A and B, or B2 to freeze row 1 and column A.
  3. Click the View tab.
  4. Click Freeze Panes, then choose Freeze Panes.
Illustration of which cell to select before using Freeze Panes in Excel, such as A4 to freeze rows 1 to 3 or B2 to freeze row 1 and column A
Illustration: which cell to select before you use Freeze Panes.
Excel worksheet with rows 1 and 2 and column A frozen while the sheet is scrolled down and to the right
Selecting B3 before Freeze Panes keeps the top two rows and column A in view.

Every row above and every column to the left of the cell you selected stays on screen while you scroll. A line marks the edge of the frozen area.

A frozen header with a long title can also be made to look like one bigger cell without widening its column.

You can also select a whole row or column instead of a cell. Click the row number 4 to freeze rows 1 to 3 with no columns, or click the column letter C to freeze columns A and B with no rows.

A worked example: in a sales sheet with a title in row 1, column names in row 2, and customer names in column A, click B3 and choose Freeze Panes. The title, the column names, and the customer names all stay in view while you scroll through months of numbers. Two header rows are typical when you build sub-columns under a main heading in Excel, and the same B3 choice keeps both header rows in view.

Use the Keyboard Instead of the Mouse

On Windows, Excel shows letters (called KeyTips) on the ribbon when you press Alt. Microsoft’s Excel keyboard shortcuts list shows that Alt, then W opens the View tab. From there, press the letters shown on screen. In current versions the sequence is usually:

  • Alt, W, F, R for Freeze Top Row
  • Alt, W, F, C for Freeze First Column
  • Alt, W, F, F for Freeze Panes, or Unfreeze Panes when something is already frozen

Press the keys one after another, not all at once. If a letter differs on your screen, follow the KeyTip Excel displays. Excel for Mac doesn’t use KeyTips, so use the View tab there.

How to Unfreeze Panes

  1. Click the View tab.
  2. Click Freeze Panes.
  3. Choose Unfreeze Panes.

The first option in the menu changes to Unfreeze Panes whenever something is frozen, as shown in the screenshot above. The freeze lines disappear and the whole sheet scrolls normally again. Your data and formatting stay the same.

Pressing Ctrl + Z doesn’t reverse a freeze, so use Unfreeze Panes. To change which rows are frozen, unfreeze first, select the new cell, and freeze again.

If rows are still missing after you unfreeze the panes, they may be hidden, so unhide all rows in Excel.

How to Split Panes Instead of Freezing Them

Splitting gives you two or four scrollable areas of the same sheet, which is handy for comparing rows that are far apart, such as row 5 and row 900. Microsoft’s Split panes to lock rows or columns in separate worksheet areas article explains:

  1. Select the row below where you want the split, or the column to the right of it. To split both ways, select the cell below and to the right of the split point.
  2. On the ribbon, select View > Window > Split.
  3. To remove the split, select Split again.
Card showing View, Window, Split to split panes in Excel
Split creates separate scrollable panes of the same worksheet.

Freeze or split? Freeze when you want headers or labels pinned while everything else moves. Split when you want to scroll two parts of the sheet on their own. A split shows a thicker bar with its own scroll bars, while a freeze shows a thin line. You can’t use both at the same time on one sheet.

Another Option: Turn Your Data Into a Table

If your data has one header row, you can format it as an Excel table. Select a cell in the data, press Ctrl + T, confirm that My table has headers is checked, and click OK. When you scroll down past the top of the table with a cell inside it selected, Excel replaces the column letters (A, B, C) with your header names.

This only helps with column names. It doesn’t keep a column in place as you scroll right, so use Freeze First Column for that.

Freeze Panes on Excel for Mac, the Web, and Mobile

Excel for Mac: On the View tab, choose Freeze Top Row, Freeze First Column, or Freeze Panes. Microsoft’s Excel for Mac freeze panes guide uses the same rule: select the row below or the column to the right of what you want frozen, or a cell such as D5 to freeze four rows and three columns. To undo it, click Unfreeze Panes on the View tab. If the buttons are grayed out, click Normal on the View tab first.

Excel for the web: Open the workbook in your browser, click View > Freeze Panes, and choose one of the three options. Choose Unfreeze Panes from the same menu to remove it.

Excel on iPad: Select the row below or the column to the right of what you want frozen, tap View, tap Freeze Panes, then tap Freeze Panes again. To unfreeze, return to View > Freeze Panes and clear the selected option.

Excel on iPhone or Android phones: Tap the three dots (…) to open the ribbon, tap Home to open the tab list, choose View, then scroll down and tap Freeze Panes. Microsoft documents the iPhone steps in its Excel for iOS freeze panes guide.

Excel for iPhone View selector and Freeze Panes command shown as two enlarged control details
On iPhone, open the ribbon, choose View, scroll down and tap Freeze Panes. These separate enlarged details follow a native iPhone example, with the command checked against Microsoft’s current instructions. The surrounding ribbon and workbook are outside the crop; appearance varies by app version.

Why Freeze Panes Is Grayed Out or Not Working

  • You are editing a cell: if a cursor is blinking inside a cell, press Enter or Esc first.
  • Page Layout view is on: Freeze Panes isn’t available while you see the sheet as printed pages. Switch to View > Normal. Here’s more on how to return Excel worksheets to Normal view.
  • The workbook or sheet is protected: on the Review tab, if you see Unprotect Sheet or a highlighted Protect Workbook button, protection is on. Remove it if you have permission, then try again.
  • There’s no View tab: Excel Starter doesn’t support every feature. Check which version of Excel you are using.
  • The wrong rows froze: you probably were scrolled down or had the wrong cell selected. Unfreeze, press Ctrl + Home, select the correct cell, and freeze again.
  • You can’t scroll far enough: too many rows or columns are frozen and they fill the window. Unfreeze, or zoom out with the slider in the bottom-right corner.
  • You see a thick bar, not a thin line: that’s a split. Click View > Split to turn it off.

Freezing panes only controls what stays on screen; to stop people from changing cells, lock cells in Excel.

Freeze Panes Questions

Will frozen rows repeat when I print?

No. Freezing only affects the screen. To print headers on every page, set Page Layout > Print Titles > Rows to repeat at top. Here’s how to repeat rows in Excel when you print. To keep columns on the page as well, see how to print a large Excel spreadsheet.

Can I freeze a row in the middle of the sheet?

No. Freeze Panes always locks rows from the top of the sheet and columns from the left edge. To keep a section from the middle of a sheet in view while you scroll elsewhere, use View > Split instead. Split divides the window into panes that scroll separately, so you can line up rows that are far apart.

Does freezing panes apply to every sheet in the workbook?

No. Each worksheet keeps its own freeze setting, so repeat the steps on every tab where you want it. Excel saves the frozen panes with the file, and they’re still there the next time you open it.

Does freezing panes lock or protect the cells?

No. Frozen cells can still be edited, sorted, and deleted. Freezing is a view setting, not protection.

How do I freeze rows in Google Sheets?

Google Sheets uses View > Freeze. Here’s how to freeze columns or rows in Google Sheets.

Once your headers are pinned, AutoFit your columns and rows so every header label fits without being cut off.