How to Use WPS Freeze on macOS

Use Freeze in WPS Sheets with 4 how-to topics: Freeze Top Row, Freeze First Column, Freeze to Active Cell, and Unfreeze Panes; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Freeze Top Row

Feature path: View → Freeze Panes → Freeze Top Row

1. Open the spreadsheet you want to review.
2. Click the View tab.
3. Click Freeze Panes.
4. Select Freeze Top Row.
5. Scroll down the worksheet and confirm that the top row stays visible.

Success Criteria

• Interface result: The top row remains visible at the top while you scroll.
• What you can do next: You can continue reviewing or editing the rest of the worksheet.

Tips While Using

• Freeze changes only the worksheet view and does not modify data.
• In collaboration mode, the frozen view can affect what other collaborators see.

2. Freeze First Column

Feature path: View → Freeze Panes → Freeze First Column

1. Open the target worksheet.
2. Click the View tab.
3. Click Freeze Panes.
4. Select Freeze First Column.
5. Scroll to the right and confirm that the first column stays visible.

Success Criteria

• Interface result: The first column remains visible on the left during horizontal scrolling.
• What you can do next: You can continue checking later columns without losing the key label column.

Tips While Using

• This is useful for keeping IDs, names, or project labels visible.

3. Freeze to Active Cell

Feature path: View → Freeze Panes → Freeze to Active Cell

1. Select the cell that marks the position you want to use.
2. For example, to freeze the first 3 rows, select A4. To keep both upper rows and left columns visible, select the cell at the needed intersection.
3. Click View and then Freeze Panes.
4. Select Freeze to Active Cell, or choose Freeze to Row X or Freeze to Column X when needed.
5. Scroll through the worksheet and check whether the upper area, left area, or both now stay visible.

Success Criteria

• Interface result: The rows above, columns to the left, or both remain visible based on the selected cell.
• What you can do next: You can continue browsing the unfrozen area of the worksheet.

Tips While Using

• The frozen range is based on the currently selected cell.
• If the result is not what you expected, select the correct cell and try again.

4. Unfreeze Panes

Feature path: View → Freeze Panes → Unfreeze Panes

1. Open a worksheet that already has frozen panes.
2. Click Freeze Panes.
3. Select Unfreeze Panes.
4. Scroll through the worksheet and confirm that all areas move normally again.

Success Criteria

• Interface result: Previously fixed rows or columns are no longer locked in place.
• What you can do next: You can scroll freely across the entire worksheet again.

Tips While Using

• After unfreezing, you can apply a different freeze setup if needed.