To keep headings visible while you scroll in Excel for Microsoft 365 on Windows, select the cell just below the rows and to the right of the columns you want to keep in view. Then choose View > Freeze Panes > Freeze Panes. Excel locks the rows above and columns to the left of that cell in place, making long worksheets easier to read.
What You’ll Need
- A worksheet open in the Excel desktop app, Excel for Microsoft 365 on Windows. Freeze panes also works in Excel for Mac and Excel for the web, though the interface can differ slightly.
- A clear idea of which rows or columns should stay visible. For example, you might keep a header row, a customer-name column, or both on screen as you scroll.
- If you are changing an existing freeze-pane setup, be prepared to unfreeze it first. Excel allows one freeze-pane arrangement per worksheet at a time.
Step-by-Step
- Open the worksheet you want to adjust. Freeze panes apply to the current worksheet, not the entire workbook. If the workbook has several sheets, click the sheet tab where you need headings to remain visible. You can configure each sheet separately.
- Decide what should stay on screen. Rows above the frozen boundary remain visible when you scroll vertically. Columns to the left of the boundary remain visible when you scroll horizontally. If you only need the first row or first column, you can use Excel’s built-in shortcuts instead of choosing a boundary cell.
- Click the correct cell for a custom freeze. Select the cell immediately below the last row you want to keep and immediately to the right of the last column you want to keep. For example, to keep rows 1 through 3 and columns A and B visible, select cell C4. Excel freezes everything above and to the left of that selection. The selected cell itself is not frozen.
- Open the Freeze Panes menu. On the Windows ribbon, click the View tab, then choose Freeze Panes in the Window group. If the ribbon is collapsed, expand it or select the View tab to reveal its commands.
- Apply the custom arrangement. In the menu, click Freeze Panes, the first option. Do not choose Freeze Top Row or Freeze First Column if you need a custom combination; those options freeze only the named row or column. Excel displays a boundary line at the frozen area.
- Check the result by scrolling. Scroll down and across the worksheet. The frozen rows should remain at the top, and frozen columns should stay at the left. For the C4 example, rows 1–3 and columns A–B should remain visible. If the result is not right, unfreeze and repeat with the correct boundary cell.
- Use a preset when it fits your layout. To keep only row 1 visible, choose View > Freeze Panes > Freeze Top Row. To keep only column A visible, choose View > Freeze Panes > Freeze First Column. These presets are useful for a simple table with headings in the first row or labels in the first column. If you need several rows or a row-and-column combination, use the cell-selection method instead.
On Mac: Select the boundary cell, then use the View tab and its Freeze Panes menu. The same selection rule applies. In Excel for the web, use View > Freeze Panes; the menu can look slightly different from the desktop ribbon, but the top-row, first-column, and custom freeze choices work on supported worksheets.
Common Mistakes
- Selecting the row or column you want frozen. For a custom freeze, Excel uses the selected cell as the dividing point. It freezes rows above the cell and columns to its left, not the cell’s own row or column. To freeze rows 1 and 2, select a cell in row 3. To freeze columns A and B, select a cell in column C.
- Choosing a preset when you need a custom boundary. Freeze Top Row always targets row 1, and Freeze First Column always targets column A. If your table headings start in row 4, for instance, the top-row preset will not keep row 4 visible. Use a custom freeze from the cell directly beneath the headings.
- Forgetting that one freeze arrangement replaces another. You cannot add a second independent freeze boundary while a different arrangement is active. Unfreeze the current panes first, then select the new boundary cell and apply the new arrangement.
- Confusing Freeze Panes with Split. Split divides the worksheet window into independently scrollable areas; it does not behave like a fixed header. Choose Freeze Panes when the goal is to keep particular rows or columns visible while scrolling through the rest of the sheet.
- Expecting a freeze to affect every sheet. The setting belongs to the worksheet where you applied it. Check other sheet tabs and configure them individually if they need their own frozen headings or identifying columns.
Tips
- Keep the frozen area as small as practical. Freezing several rows and columns can leave little room for the data you are reviewing, especially on a laptop display. Usually, the heading rows and one or two identifier columns are enough.
- Use Freeze Panes for wide as well as long worksheets. If you scroll horizontally through monthly figures, keeping a name or category column on the left helps you identify each row. Select the cell just to the right of the columns to retain.
- Set up headings before freezing. If your table has a title above its column labels, decide whether you need both visible. To keep rows 1 through 4, select a cell in row 5 before choosing the custom Freeze Panes command.
- Review the boundary before sharing. Scroll vertically and horizontally to confirm that the visible labels make sense with the data. A coworker opening the workbook may not immediately know why certain rows stay in place.
- Unfreeze before rearranging a layout. If you insert or remove rows and columns, check whether the existing boundary still matches the table. Removing the freeze and applying it again to the new boundary is often clearer than trying to work around an outdated setup.
- Remember that freezing does not protect cells. It changes what stays visible during scrolling; it does not prevent edits, hide data, or lock the worksheet. Use worksheet protection separately if you need to restrict changes.
Troubleshooting
- The wrong rows or columns stay visible: Choose View > Freeze Panes > Unfreeze Panes, then select the correct boundary cell and apply Freeze Panes again. Count from the top and left edges of the worksheet: to freeze through row 5, select a cell in row 6; to freeze through column D, select a cell in column E.
- The Freeze Panes command is unavailable or does not respond: Switch to View > Normal if the worksheet is in a different view, then check the menu again. Also check whether the workbook is open in a mode or environment that restricts editing, and whether you have permission to change it. In a browser, try opening the workbook in the desktop app if the web interface does not offer the option you need.
- The previous freeze is still active: First select View > Freeze Panes > Unfreeze Panes. Then click the intended boundary cell. Selecting a new cell alone does not change the existing frozen area.
- The header seems to disappear despite freezing: Verify that you froze the row containing the actual headings, not just the first row. If there are title rows above the headings, use a custom boundary below all rows that should remain visible. Also confirm you are scrolling within the same worksheet where the freeze was applied.
- The sheet looks divided into scrolling sections: You may have selected Split instead of Freeze Panes. Turn off Split from the View tab, then apply Freeze Panes using the correct boundary cell. Frozen panes move together with the worksheet; split sections scroll independently.
Frequently Asked Questions
Can I freeze both rows and columns at the same time?
Yes. Select the cell below the rows and to the right of the columns you want to retain, then choose View > Freeze Panes > Freeze Panes. Selecting C4 freezes rows 1–3 and columns A–B.
How do I freeze the first two rows?
Click a cell in row 3, such as A3, then choose View > Freeze Panes > Freeze Panes. The first two rows stay visible while you scroll down.
Can I freeze a row that is not at the top?
Freeze Panes keeps all worksheet rows above the selected boundary in view. It cannot freeze an isolated middle row while allowing rows above it to scroll away. If the headings are in row 5, freezing through row 5 also keeps rows 1–4 visible.
How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current freeze arrangement on the active worksheet; it does not delete any worksheet content.
Will frozen panes appear when I print?
No. Freeze Panes affects on-screen scrolling, not printed page layout. To repeat headings on printed pages, use Page Layout > Print Titles and set the rows or columns to repeat.
Does freezing panes lock cells from editing?
No. It only keeps specified rows or columns visible as you navigate. To prevent edits, use Excel’s sheet-protection features instead; freezing panes does not change cell permissions.
Related
- Delete Everything Highlighted in Excel: Step-by-Step
- How to Delete Extra Rows in Excel
- How to Delete Duplicate Values in Excel Without Losing Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Sum a Row in Google Sheets: Simple FormulaTo sum a row in Google Sheets, put the total in an empty cell and enter =SUM(B2:F2). This…
- Attendance and Leave Tracker Excel Template: Setup GuideAn attendance and leave tracker Excel template is a workbook that records each employee’s workday status, tracks approved…
- Excel Attendance Format: A Clear Monthly Attendance TrackerAn Excel attendance format is a spreadsheet that lists each person in a row and each date in…
- How to Add Color to a Dropdown List in Excel with RulesTo add color to a dropdown selection in Excel, keep the dropdown list as it is and use…
- Excel Data Validation: Change Cell Colors AutomaticallyExcel data validation does not change a cell’s color by itself. To color a cell when someone selects…
- How to Make a Bifold Brochure in Word, Step by StepTo make a bifold brochure in Microsoft Word, create a two-page landscape document, divide each page into two…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.