About This Article
This article is created using an automated generation workflow powered by generative AI. Referring to Microsoft Support documentation for freezing and unfreezing panes, we have organized the procedure for freezing rows and columns simultaneously.
Verification Status: 📘 Microsoft Official Specification Verified / Excel Hardware Not TestedWhen opening spreadsheets with numerous rows or columns in Excel, scrolling down may cause column headers to disappear, and scrolling right may hide item names. By using freeze panes, you can review your table while keeping headers and identification columns visible on screen.
- Supported Environments, Capabilities, and Limitations (Officially Confirmed: October 15, 2026)
- “Keeping visible” and “preventing editing” are distinct functions.
- When procedures do not yield the expected results
- How it differs from Copilot
- 1. Freezing "Above and to the Left of the Selected Cell"
- 2. Try it out with a reception log
- 3. Difference from Freezing the Top Row
- 4. Unfreezing Panes
- 5. "Freeze" and "Split" Are Different
- 6. Common Mistakes
- 7. For business use
- Procedure for modifying the frozen range
- Official Information / Primary Sources
Supported Environments, Capabilities, and Limitations (Officially Confirmed: October 15, 2026)
| Item | Conditions and Constraints |
|---|---|
| Target | Excel Freeze PanesSeparate from Copilot data analysis and editing |
| Supported | Microsoft 365 Excel, desktop versions such as Excel 2024/2021, and Excel for the Web (different UI) |
| Usage Conditions | License to use compatible Excel. Additional Copilot license not required |
| Operation Target | Display state of the sheet in the currently open workbook |
| Capabilities | Scroll while keeping rows above and columns to the left of the selected cell visible |
| What cannot be done | Lock cell permissions, prohibit row editing, automatically update other workbooks |
| Limitations | Depends on the frozen range and window size. Verify mobile and other UIs separately. |
| Note | Freezing is not a protection feature. Configure file sharing or access restrictions separately if required. |
“Keeping visible” and “preventing editing” are distinct functions.
Freeze Panes is a display function that keeps headers visible while scrolling. For a ledger with reception numbers in column A and item names in row 1, selecting cell B2 and freezing panes allows column A to remain visible when scrolling right, and row 1 to remain visible when scrolling down. However, this operation does not restrict editing in column A or row 1. To prevent unintended modifications to headers, consider alternative mechanisms such as worksheet protection.
Furthermore, the display results of freezing panes depend on the user's Excel window size. For example, freezing the top 10 rows on a small-screen device reduces the viewing area for data below. For operational templates, freezing only the minimum necessary headers is often easier to use.
When procedures do not yield the expected results
To freeze only the first row, you can use dedicated commands such as “Freeze Top Row” under the View tab. To freeze both the first row and column A simultaneously, verify the procedure of selecting cell B2 and choosing “Freeze Panes.” If another freeze setting is already active, cancel it first and then reselect the new range.
Does column A remain visible when scrolling horizontally only?、Does row 1 remain visible when scrolling vertically only?Observing these separately makes it less likely to confuse row and column settings. If identically named menus are located elsewhere in Excel for the Web, verify the specific application type.
How it differs from Copilot
Asking Copilot “Explain how to freeze the headers of this table” may provide step-by-step guidance, but the explanation written in the chat is not proof that the display settings of the source workbook have been changed. Even when Copilot within the Excel application assists with editing, you must verify the modification results and save destination of the source file.
Official source:Microsoft Support — Freeze panesThe operational results shown here are expected examples and do not constitute physical device testing.
Keeping headers visible with Excel Freeze Panes: How to freeze rows and columns simultaneously
1. Freezing "Above and to the Left of the Selected Cell"
The most important thing to understand about freezing panes is not the selected cell itself, but thatthe rows above and the columns to the left of the selected cell are frozen.
For example, in a table where column A is the reception number, column B is the person in charge, and row 1 is the header, selecting cell B2 and freezing panes will lock row 1 and column A in place.
| Range to freeze | Example of cell to select |
|---|---|
| Row 1 | A2 |
| Row 1 and Column A | B2 |
| Rows 1-2 and Columns A-B | C3 |
| Columns A-B | C1 |
Formula:Microsoft Support — Freeze panes to lock rows and columns
2. Try it out with a reception log
Create the following dummy data in a new workbook.
| Reception Number | Person in charge | Receipt date | Category |
|---|---|---|---|
| A001 | Sato | 10/1 | PC |
| A002 | Suzuki | 10/2 | Account |
| A003 | Tanaka | 10/3 | Supplies |
Make the first row the header and column A the reception number. Add columns to the right and rows to the bottom so that the sheet is scrollable.
Click cell B2.
Open the View tab.
Select Freeze Panes -> Freeze Panes.
Scroll down to verify that the first row remains visible.
Scroll to the right to verify that column A remains visible.
In this example, both the header and the reception number remain on the screen, making it easier to keep track of row meanings when checking distant cells.
3. Difference from Freezing the Top Row
Freezing the top row is an operation primarily intended to lock the top row in place regardless of which cell is selected. On the other hand, Freezing Panes allows you to freeze multiple rows and columns using the selected cell as the boundary.
If the table has titles and headers in rows 1 and 2 and important identification information in columns A and B, selecting cell C3 and freezing is a clear example.
However, freezing too much narrows the viewable area available for actual scrolling. On laptops with small screens, freeze only the minimum necessary rows and columns.
4. Unfreezing Panes
To cancel the freeze, select View -> Freeze Panes -> Unfreeze Panes. The freeze boundary lines will disappear, returning the entire table to a scrollable state.
Official Reference:Microsoft Support – Unfreeze locked panes
5. "Freeze" and "Split" Are Different
Freezing panes is a feature designed to keep specific rows and columns, such as headers, continuously visible. Splitting divides the same sheet into multiple display areas to check different positions independently.
If you want to enter data while keeping headers visible, freezing is suitable. If you want to compare distant positions on the same sheet, splitting can be useful. Because their purposes differ, use the appropriate feature despite their similar menus.
6. Common Mistakes
Selecting cell B2 while expecting column B to be frozen as well
What gets frozen is to the left of the selected cell. For B2, only column A is frozen. If you want to freeze column B as well, select cell C2.
The header is not on the first row
If the table header is on the third row, selecting a cell in the fourth row and freezing will keep rows 1 to 3 visible. However, note that explanatory rows above will also be frozen.
Expecting headers to repeat when printed
Freezing panes is a screen display feature. It is separate from the setting to repeat headers on each page when printing. Print headers are configured via print titles in page layout.
7. For business use
In wide ledgers such as monthly summaries or application lists, freezing column A and the header in row 1 helps reduce data review errors. On the other hand, since changing the frozen range during data entry can confuse users, it is effective to standardize the frozen range in shared templates.
After the operation, scroll both downward and to the right to verify that the expected headers remain in place.
Procedure for modifying the frozen range
First, freeze row 1 and column A based on cell B2. If you then want to keep two header rows instead, cancel the existing freeze and select a different cell. Selecting cell C3 is an example where rows 1-2 and columns A-B are frozen. The required range is determined by the table's width and the screen size.
During collaboration, display areas differ depending on the user's device even within the same workbook, so the same view is not necessarily optimal for everyone. Including both the header range to freeze and the unfreezing method in the operation manual makes it easier for users to revert the settings.
Finally, freezing panes only assists with scrolling through the table and is not a protection function to prevent erroneous entry or data deletion. Measures against input errors, such as data validation or sheet protection, should be considered separately to avoid confusing their roles.
