Feature Summary

The Freeze Panes feature is used to lock header rows or header columns in a spreadsheet so they remain visible while scrolling through large amounts of data, making it easier for team members to view data efficiently in collaboration mode.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Freeze Top Row

Feature Entry
"View" tab → "Freeze Panes" → "Freeze Top Row"

  1. Click the View tab
  2. Click the "Freeze Panes" button
  3. Select "Freeze Top Row"
  4. When scrolling the spreadsheet, the top row will always remain fixed in place

截图

Freeze First Column

Feature Entry
"View" tab → "Freeze Panes" → "Freeze First Column"

  1. Click the View tab
  2. Click the "Freeze Panes" button
  3. Select "Freeze First Column"
  4. When scrolling the spreadsheet horizontally, the first column will always remain fixed in place

截图

Freeze Up to Active Cell

Feature Entry
"View" tab → "Freeze Panes" → "Freeze Up to Active Cell"

  1. Select the first cell below the target rows (e.g., to freeze the first 3 rows, select A4)
  2. Click "Freeze Panes" in the View tab
  3. Select "Freeze Up to Active Cell" / "Freeze Up to Row X" / "Freeze Up to Column X :
  • "Freeze Up to Active Cell" : Freezes the area above and to the left of the active cell
  • "Freeze Up to Row X" : Freezes the area above the active cell
  • "Freeze Up to Column X" : Freezes the area to the left of the active cell

截图

Unfreeze Panes

Feature Entry
"View" tab → "Freeze Panes" → "Unfreeze Panes"

  1. Click the "Freeze Panes" button
  2. Select "Unfreeze Panes"
  3. All freeze effects will be removed and the spreadsheet will return to free scrolling

截图

FAQ

Q1: Will the freeze I set in collaboration mode affect others?

  • Solution: Yes, freezing will affect the view of other collaborating users

Q2: Why can't some rows/columns be frozen after freezing panes?

  • Solution: The freeze operation is based on the selected position and can only freeze rows above and columns to the left of the selected position. If you need to freeze a specific position, click the cell at the target position first and then perform the freeze.

Notes

  1. Freezing panes only affects the display and does not modify or lock any data
  2. Frozen areas will not automatically repeat as print headers; you need to set print titles separately
  3. Freeze Panes can also be operated from the "Home" tab
  4. It is recommended to use the Freeze Panes feature when dealing with large amounts of data; freezing is unnecessary for small datasets