To double freeze panes in Excel—that is, keep both rows and columns visible while you scroll—select the cell immediately below the rows and immediately to the right of the columns you want to keep, then choose View > Freeze Panes > Freeze Panes. For example, select C2 to keep row 1 and columns A:B on screen. The method works in Excel for Microsoft 365 on Windows; Mac and web notes appear below.
Freeze Panes is useful when a worksheet has headings across the top and identifiers down the left, such as a sales table with column labels and customer names. Once frozen, those parts stay visible as you move through the rest of the sheet. Excel freezes the rows above and the columns to the left of the selected cell, not two unrelated areas anywhere on the worksheet.
What You’ll Need
- A workbook open in Excel for Microsoft 365. The instructions below use the Windows desktop app.
- A worksheet with the headings and identifying columns you want to keep visible arranged at the top and left of the data.
- A clear idea of how many top rows and left columns to freeze. You can change the choice later by unfreezing and setting it again.
Step-by-Step
- Open the worksheet you want to work on. Freeze Panes applies to the active worksheet, so click its sheet tab at the bottom of the workbook. If you have several sheets, check that you are on the one you intend to change. You do not need to select the full data range or convert it to a table.
- Decide which top rows should remain visible. Count from the first row of the sheet downward. If you want only the first row to stay visible, freeze one row. If you have a title in row 1 and column headings in row 2, and want both to remain visible, freeze two rows. Excel freezes every row above the selected cell, so you cannot freeze row 2 by itself while leaving row 1 scrolling.
- Decide which left columns should remain visible. Count from column A toward the right. For example, if column A contains an ID and column B contains a person’s name, freeze two columns to keep both identifiers in view. Excel freezes all columns to the left of the selected cell. You cannot use this command to pin an isolated column while allowing an earlier column to scroll normally.
- Select the intersection cell. Click the cell one row below the last row to freeze and one column to the right of the last column to freeze. To freeze row 1 and columns A:B, select C2. To freeze rows 1:2 and column A, select B3. The selected cell itself and everything below or to its right remains in the scrolling area. Take care to select the cell, not just its row or column heading.
- Open the Freeze Panes command. On the Windows ribbon, select the View tab, then choose Freeze Panes in the Window group. If the menu offers Freeze Panes, Freeze Top Row, Freeze First Column, and Unfreeze Panes, choose the first option: Freeze Panes. The general command uses your selected cell to set both the row and column boundaries.
- Check the result by scrolling. Scroll down and confirm the chosen top rows remain visible; then scroll right and confirm the chosen left columns remain visible. You should see a subtle boundary line below the frozen rows and to the right of the frozen columns. If you selected C2, row 1 and columns A:B should stay in place while the rest of the worksheet moves.
- Adjust the freeze if needed. If the wrong rows or columns are fixed, return to View > Freeze Panes > Unfreeze Panes. Then select the correct intersection cell and choose View > Freeze Panes > Freeze Panes again. Excel does not let you drag the boundary to revise the frozen area; you must unfreeze and reset it.
Mac and Excel for the web: In Excel for Mac, select the intersection cell and use View > Freeze Panes > Freeze Panes; the precise ribbon layout can vary with the app version. In Excel for the web, select the cell and use View > Freeze Panes, then select Freeze Panes if the menu displays that option. The same selection rule applies. If a command is unavailable or the workbook is in a restricted editing mode, open it in the desktop app or check whether you have permission to edit it.
Common Mistakes
- Choosing Freeze Top Row or Freeze First Column instead. These are preset commands. They freeze just one row or just one column and do not combine both choices. To freeze rows and columns together, select the correct intersection cell and use the general Freeze Panes command.
- Selecting the last row or column you want frozen. Excel freezes what is above and left of the selected cell, not the selected cell’s own row or column. For row 1 and columns A:B, C2 is the correct selection; B1 is not.
- Expecting only one particular row or column to stay fixed. Freeze Panes creates continuous frozen areas starting at the top and left edges. It cannot keep a middle row or a separated group of columns fixed while earlier ones scroll.
- Forgetting an existing freeze. Applying a new setup while a previous freeze is active can be confusing, and the selection may not produce the layout you expect. Unfreeze first, then select the desired cell and apply the command again.
- Using Split as if it were Freeze Panes. Split divides the worksheet into scrollable panes; those panes can move independently. Freeze Panes keeps the designated top rows and left columns stationary as you scroll the remaining area. Choose the feature that matches the behavior you need.
- Testing only by scrolling vertically. A row freeze may look correct even if the columns were set incorrectly. Test both directions, especially when you are setting up a wide worksheet.
Tips
- Use the intersection rule as a quick check. The active cell should sit at the top-left corner of the area that will scroll. If the scrolling area should begin at C2, select C2. This makes the row and column boundaries easier to reason about.
- Keep the frozen area compact. Freezing many rows or columns leaves less room for the data you need to inspect, particularly on a laptop display. Freeze only the headings and identifiers that are useful while navigating.
- Use a sensible worksheet layout. Place column labels in the first few rows and key identifiers in the first few columns before setting panes. If a title or blank spacer row sits above the headings, include it only if you want it to remain visible too.
- Save after arranging the view. The freeze setting is associated with the worksheet and is normally retained when the workbook is saved. Save the file after confirming the layout, especially if colleagues will use the workbook. A recipient can still change the view in their copy.
- Remember that freezing is a viewing aid. It does not lock cells, prevent edits, protect a sheet, or change how data is sorted or calculated. Use worksheet protection or other controls separately if you need to restrict editing.
Troubleshooting
The wrong number of rows or columns stays visible. Unfreeze the current setup, count the rows and columns again, and select the cell at the scrolling area’s upper-left corner. For example, if rows 1:3 and columns A:B should stay put, select C4. Then use the general Freeze Panes option, not one of the single-row or single-column presets.
The menu command is unavailable or grayed out. Click a normal cell in the worksheet and check that the workbook is not in a mode that prevents editing. If the sheet is protected or the file is opened read-only, you may need permission or an editable copy. In Excel for the web, some workbook or browser states may limit commands; try opening the workbook in the desktop app.
The freeze seems to disappear when you scroll. Check that you are scrolling the worksheet rather than a separate pane, and look for the boundary lines. If you used View > Split, turn off Split and set Freeze Panes instead. Also confirm that you changed the right sheet: each worksheet can have its own view setting.
Rows or columns are hidden or the boundary is hard to see. A hidden row or column near the freeze boundary can make the visible result seem unexpected. Unhide the relevant rows or columns temporarily, inspect the selection and boundary, and then hide them again if appropriate. Zooming in can also make the line easier to spot. Remember that frozen panes follow sheet rows and columns, not the labels currently visible after filtering.
The worksheet has merged cells near the intended boundary. Merged headings can make selecting and interpreting the boundary awkward. Click a regular cell at the intended intersection if possible, and consider whether the merged layout is necessary. If the selection behaves unexpectedly, unfreeze and try again from a cell outside the merged area.
Frequently Asked Questions
Can I freeze the top row and first column at the same time?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. This keeps row 1 and column A visible. Do not select Freeze Top Row or Freeze First Column, because either preset applies only its named boundary.
Can I freeze more than one row and more than one column?
Yes. Select the cell immediately below the last row and immediately to the right of the last column you want fixed. For example, selecting D4 freezes rows 1:3 and columns A:C. The selection defines continuous frozen bands from the top and left edges.
Can I freeze a row in the middle of my worksheet?
Not with Freeze Panes. The feature freezes rows from the top down and columns from the left across. To keep a middle row visible, you could reorganize the sheet so the important heading is at the top, or use Split to create independently scrollable areas instead.
Why does selecting a cell not seem to freeze that exact cell?
The selected cell is the first cell in the scrolling section, not the cell that becomes fixed. Excel freezes rows above it and columns to its left. If you want row 1 and columns A:B frozen, select C2.
Does freezing panes protect my data or affect printing?
No. It changes how the worksheet appears while you navigate; it does not stop editing and does not set printed titles. To repeat headings on printed pages, use Page Layout > Print Titles. To restrict edits, use the sheet-protection options separately.
Will the freeze setting work on Mac and in a browser?
Excel for Mac and Excel for the web support freezing rows and columns, though the interface may look different from Windows. Use the same intersection-cell method and look under View for Freeze Panes. If the web workbook does not allow the command, try the desktop app or check your editing access.
Related
- How to Delete One Cell in Excel and Shift Nearby Data
- How to Delete Microsoft Excel Without Losing Files
- How to Delete Multiple Cells at Once in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Cleanup Guide: How to Clean and Organize DataTo clean an Excel workbook, first save a copy, inspect the data, then standardize text and formats, check…
- Outlook Share Calendar With a Distribution List?Outlook can send a calendar-sharing invitation to a distribution list, but that does not reliably give every member…
- Excel Text to Columns: Choosing a Number DelimiterExcel’s Text to Columns has no special “number delimiter”: choose the character—such as a comma, tab, space, semicolon,…
- Consolidate CSV Files in One Excel WorkbookYes. In Excel for Microsoft 365 on Windows, use Power Query to combine multiple CSV files into one…
- Excel: How to Reverse the Order of Data in a ColumnIn Excel for Microsoft 365, the quickest way to reverse a column without changing the source is to…
- Excel Certifications: The Current Options ExplainedThe main Microsoft Excel certifications are Microsoft Office Specialist (MOS) Excel Associate for Microsoft 365 Apps (exam MO-210)…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.