How to Use WPS Freeze on macOS

This how-to guide includes 8 task topics for freezing the top row, first column, selected areas, and unfreezing panes from two interface paths; 8 items are free and 0 items are membership-related.

How-to Index

How-to Guide

1. Freeze Top Row from the View Tab

Feature entry: View → Freeze Panes → Freeze Top Row

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

Success Criteria

• Interface result: The top row remains fixed at the top while you scroll down.
• Next action available: You can continue reviewing lower rows while keeping the header visible.

Tips While Using

• Common mistake: If you do not scroll inside the worksheet area, it may look like the command did not take effect.

2. Freeze First Column from the View Tab

Feature entry: View → Freeze Panes → Freeze First Column

1. Open the worksheet you want to review.
2. Click the View tab.
3. Click the Freeze Panes drop-down menu.
4. Select Freeze First Column.
5. Scroll right and confirm that the first column stays visible.

Success Criteria

• Interface result: The first column remains fixed on the left while you scroll right.
• Next action available: You can continue reviewing data on the right while keeping the key column visible.

Tips While Using

• Common mistake: Mixing up Freeze First Column with freezing a selected area can produce a different fixed range than expected.

3. Freeze a Selected Area from the View Tab

Feature entry: View → Freeze Panes

1. Select the cell below and to the right of the area you want to keep visible.
2. Click the View tab.
3. Click the Freeze Panes drop-down menu.
4. Select the option to freeze up to the target row, column, or both.
5. Scroll through the worksheet and check whether the intended rows and columns remain visible.

Success Criteria

• Interface result: The rows above and columns to the left of the selected cell stay fixed.
• Next action available: You can scroll both vertically and horizontally while keeping the reference area visible.

Tips While Using

• Common mistake: Selecting the wrong cell position causes the frozen range to be larger or smaller than expected.

4. Unfreeze Panes from the View Tab

Feature entry: View → Freeze Panes → Unfreeze Panes

1. Click the View tab.
2. Click the Freeze Panes drop-down menu.
3. Select Unfreeze Panes.
4. Scroll through the worksheet and confirm that rows and columns move normally again.

Success Criteria

• Interface result: Previously fixed rows or columns no longer stay at the edge of the worksheet.
• Next action available: You can set a new freeze range if needed.

Tips While Using

• Common mistake: After unfreezing, users sometimes continue reviewing a large table without setting a new reference area.

5. Freeze Top Row from the Home Tab

Feature entry: Home → Freeze → Freeze Top Row

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

Success Criteria

• Interface result: The top row remains fixed at the top.
• Next action available: You can continue reviewing the rows below.

Tips While Using

• Common mistake: If the related drop-down menu is not expanded on the Home tab, the command may be easy to miss.

6. Freeze First Column from the Home Tab

Feature entry: Home → Data Processing → Freeze → Freeze First Column

1. Click Data Processing on the Home tab.
2. Click the Freeze drop-down menu.
3. Select Freeze First Column.
4. Scroll right and confirm that the first column stays visible.

Success Criteria

• Interface result: The first column remains fixed on the left.
• Next action available: You can continue reviewing the data area on the right.

Tips While Using

• Common mistake: Opening Data Processing without continuing into the Freeze menu can make the command seem unavailable.

7. Freeze a Selected Area from the Home Tab

Feature entry: Home → Data Processing → Freeze

1. Select the cell below and to the right of the area you want to keep visible.
2. Click Data Processing on the Home tab.
3. Click the Freeze drop-down menu.
4. Select the option to freeze up to the target row, column, or both.
5. Scroll through the worksheet and confirm that the selected area stays fixed.

Success Criteria

• Interface result: The target rows and columns remain visible.
• Next action available: You can keep reference fields visible in a large worksheet.

Tips While Using

• Common mistake: If you do not select the correct cell first, the frozen range will not match your expectation.

8. Unfreeze Panes from the Home Tab

Feature entry: Home → Data Processing → Freeze → Unfreeze Panes

1. Click Data Processing on the Home tab.
2. Click the Freeze drop-down menu.
3. Select Unfreeze Panes.
4. Scroll through the worksheet and confirm that the freeze state has been removed.

Success Criteria

• Interface result: The worksheet returns to normal scrolling.
• Next action available: You can apply another freeze method if needed.

Tips While Using

• Common mistake: After unfreezing, some users think worksheet content changed, but only the view state changed.