How to Freeze the Second Row in Excel While Scrolling

To keep the second row visible while you scroll in Excel, select cell A3, then choose View > Freeze Panes > Freeze Panes. Excel freezes every row above the selected cell, so this keeps both row 1 and row 2 on screen; Excel cannot freeze row 2 by itself while allowing row 1 to scroll away. The steps below are for Excel for Microsoft 365 on Windows, with notes for Mac and the web version.

What You’ll Need

An Excel workbook with at least three rows. The row you select needs to be below the rows you want to keep visible.
A worksheet that is not in a mode or state preventing changes, such as a protected sheet where you do not have permission to change the view.
A decision about whether row 1 should remain visible too. With Excel’s standard Freeze Panes command, keeping row 2 fixed also keeps row 1 fixed.

You do not need to add a formula or change the data. Freezing panes affects how the worksheet displays as you scroll; it does not move, edit, or lock the contents of the cells. It is a view setting for the worksheet, not a way to prevent other people from changing its values.

Step-by-Step

Open the worksheet you want to adjust. Click the worksheet tab at the bottom of the Excel window if the workbook has several sheets. Freeze Panes applies to the active sheet, so check that you are on the sheet where row 2 contains the information you want to keep in view. The setting does not automatically carry over to other worksheets.
Check whether another freeze setting is already active. Look at View > Freeze Panes. If the menu offers Unfreeze Panes, a freeze is already in effect. Clear it before setting a new boundary: choose View > Freeze Panes > Unfreeze Panes. This avoids confusion about which rows and columns Excel is currently holding in place.
Click cell A3. Select the cell at the intersection of column A and row 3, or click the Name Box to the left of the formula bar, type A3, and press Enter. The exact selection matters: Excel freezes the rows above the active cell and the columns to its left. A3 is in the first column, so there are no columns to its left to freeze, and rows 1 and 2 are above it.
Open the Freeze Panes menu. On Windows, select the View tab on the ribbon, then open Freeze Panes in the Window group. Depending on the size of the Excel window, the button may be inside a compact or expanded group, but it remains on the View tab. Do not choose Freeze Top Row if your goal is to keep row 2 visible.
Choose Freeze Panes from the menu. Select the menu item named Freeze Panes, usually the first option. This is different from the separate Freeze Top Row option, which freezes only row 1. After you choose Freeze Panes, Excel draws a subtle boundary under the frozen rows, typically beneath row 2 in this setup.
Scroll down to confirm the result. Use the mouse wheel, the vertical scroll bar, or the arrow keys to move down the worksheet. Rows 1 and 2 should remain at the top of the grid while the rows below them move. If you only see row 1 staying in place, the wrong menu option was selected; unfreeze and repeat the steps with A3 selected.
Check that the visible rows contain what you need. Freeze Panes keeps the top two rows visible together, not just the second one. If row 1 is a title and row 2 contains column headings, this is usually useful. If row 1 is not needed, Excel has no standard Freeze Panes setting that pins row 2 alone. Consider moving the desired heading into row 1 or creating a separate layout that places it at the top.
Save the workbook if you want to keep the view setting. Use Ctrl+S on Windows. Excel generally saves freeze settings with the workbook and worksheet, so the view is available when the file is reopened. If you share the workbook, remember that another person may have a different active sheet or window arrangement, so ask them to check the relevant sheet.

On a Windows keyboard, Excel’s ribbon KeyTips may let you use Alt, then W, F, F to reach Freeze Panes in an English-language Microsoft 365 installation. KeyTips can vary with language, ribbon customization, and version, so use the visible ribbon command if that sequence does not match your screen. There is no need to use a shortcut for this task.

In Excel for Mac, select A3 and use the View tab or View menu, then choose Freeze Panes and the Freeze Panes command. The menu wording and placement can vary slightly by release, but the selection rule is the same: rows above the active cell are frozen. In Excel for the web, select A3, open View, and choose Freeze Panes > Freeze Panes. If the web interface presents a shorter menu, choose the command that freezes panes based on the current selection rather than Freeze Top Row.

Common Mistakes

Choosing Freeze Top Row. This option freezes only row 1, regardless of which cell is selected. It is useful when the first row is the only header you need, but it does not pin row 2. To keep row 2 visible, unfreeze the current setting, select A3, and choose Freeze Panes instead.

Selecting the wrong row or cell. If you select A2, Excel freezes only row 1. If you select A4, it freezes rows 1 through 3. That behavior is intentional: Excel freezes the entire area above and to the left of the selected cell, not just the row containing that cell. Confirm the active-cell address before using the command.

Expecting row 2 to be pinned by itself. Freeze Panes always freezes a continuous area starting at the top or left edge. You cannot keep row 2 fixed while row 1 scrolls away with this feature. If that exact arrangement is essential, rearrange the worksheet so the needed content is in the first row, or make a separate presentation or report sheet with the desired layout.

Forgetting an earlier freeze or split. A workbook may already have frozen rows or columns, which changes what happens when you make another selection. A split view can also make the sheet look divided into independently scrolling regions. Choose View > Freeze Panes > Unfreeze Panes before starting over, and check the View tab for a Split command if the worksheet still behaves unexpectedly.

Tips

If you want to freeze both rows and columns, choose the cell just below the rows and just to the right of the columns you want fixed. For example, selecting C3 and choosing View > Freeze Panes > Freeze Panes holds rows 1 and 2 and columns A and B. For the second row only as part of the top area, use A3; selecting a cell farther right adds frozen columns as well.

Make the rows you are freezing compact enough to leave room for the data you need to inspect. If rows 1 and 2 are unusually tall, the remaining scrolling area may be small, especially on a laptop display. You can adjust row height by dragging the boundary between row numbers or by using Home > Format > Row Height. Check the result at the zoom level you normally use.

Freeze Panes is different from hiding rows, protecting a worksheet, or repeating headings on printed pages. It affects on-screen scrolling in the worksheet. If you need headings to print at the top of every page, use the Page Layout tab’s Print Titles settings instead. If you need to stop edits, use sheet protection; freezing rows does not protect cells.

For a workbook with multiple sheets, apply and check the setting on each sheet where it is needed. You can often select several sheet tabs and group sheets for some actions, but doing so can also make unintended changes across all selected sheets. For a simple and predictable result, set the freeze point on one sheet at a time and verify it before moving to the next.

Troubleshooting

The second row disappears when I scroll. Check that you used Freeze Panes rather than Freeze Top Row. Choose Unfreeze Panes, click A3, and select Freeze Panes again. Scroll down a few rows to test; the frozen area should stay above the horizontal boundary.

More rows are frozen than I intended. The selected cell was probably below row 3. First unfreeze the sheet, then select A3 precisely. If you clicked a cell in column C or later, Excel may also freeze the columns to its left, so use column A when you only want rows held in place.

The Freeze Panes command is unavailable or does not respond. Confirm that a worksheet cell is selected and that you are on the correct sheet. If the sheet is protected or the workbook is opened in a restricted state, check whether you have permission to change its view or edit the workbook. In a browser, wait for the workbook to finish loading and try again; if the command is missing, open the file in the desktop app and use the View tab.

The worksheet still seems divided after unfreezing. You may be seeing a split rather than frozen panes. On the View tab, turn off Split if it is active, then scroll again. A split divides the window into sections; freezing keeps designated top rows or left columns in place as the rest of the sheet scrolls. They can look similar at first, but they behave differently.

The boundary is hard to see. The line marking frozen panes can be subtle. Scroll the worksheet and watch whether rows 1 and 2 remain stationary while the row numbers below change position. If needed, zoom in or use a worksheet with clearer row labels temporarily to confirm the freeze point; do not judge solely by the line’s appearance.

Frequently Asked Questions

Can I freeze only row 2 and let row 1 scroll?
No. Excel’s Freeze Panes command freezes a continuous block starting at row 1. To keep row 2 visible, you must also freeze row 1. Move the content you need into the first row if you require it to be the sole fixed row.

Why does selecting row 2 freeze row 1 instead?
The selected row is not automatically the row Excel freezes. Excel freezes rows above the active cell or selected row boundary. Selecting row 2 and using Freeze Panes therefore holds row 1 in place; select A3 to hold rows 1 and 2.

Does freezing row 2 change or lock my data?
No. It changes the worksheet’s scrolling view only. Cells remain editable unless separate protection or permissions prevent changes, and the data itself is not moved or altered.

Will the freeze work in Excel for Mac or Excel for the web?
Yes. Select A3 and use the View tab’s Freeze Panes command in the desktop Mac app or the web app. Menu placement can vary, but the same rule applies: Excel freezes rows above the selected cell.

Can I freeze rows 1 and 2 and also freeze columns?
Yes. Select a cell below the rows and to the right of the columns to freeze. For example, C3 freezes rows 1 and 2 plus columns A and B. Choose A3 instead when you want no columns frozen.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.