How to Use WPS Freeze Panes on iOS

Use Freeze Panes with 4 how-to topics, including 4 free topics and 0 membership-related topics; choose a task from the index and follow the steps to complete the setup.

How-to Index

How-to Guide

1. Freeze to the Active Cell

Entry path: View → Freeze

1. Open the spreadsheet you want to work with.
2. Place the cursor in the cell that sits below and to the right of the area you want to keep visible.
3. Select the View tab.
4. Tap Freeze.
5. Select Freeze to Active Cell.
6. Scroll through the sheet and confirm that the rows above and columns to the left stay visible.

Success Criteria

• Interface result: After scrolling, the rows above and columns to the left of the selected cell remain fixed.
• What you can do next: You can continue reviewing, editing, or checking other data.

Tips While Using

• Common mistake: If the cursor is placed in the wrong cell, the frozen area may not match what you expected.
• Environment note: This setting applies to the current worksheet view.

2. Freeze the Top Row

Entry path: View → Freeze

1. Open the spreadsheet and go to the worksheet you want to review.
2. Select the View tab.
3. Tap Freeze.
4. Select Freeze Top Row.
5. Scroll down and check whether the top row stays visible.

Success Criteria

• Interface result: The top row remains fixed during vertical scrolling.
• What you can do next: You can keep matching headers with the data below.

Tips While Using

• Common mistake: If the worksheet does not use the first row as a clear header row, the effect may be less obvious.

3. Freeze the First Column

Entry path: View → Freeze

1. Open the spreadsheet and go to the target worksheet.
2. Select the View tab.
3. Tap Freeze.
4. Select Freeze First Column.
5. Scroll sideways and confirm that the first column stays visible.

Success Criteria

• Interface result: The first column remains fixed during horizontal scrolling.
• What you can do next: You can keep viewing name, ID, or category columns while moving across the sheet.

Tips While Using

• Common mistake: If the key field is not in the first column, use Freeze to the Active Cell instead.

4. Unfreeze Panes

Entry path: View → Freeze

1. Open the worksheet where Freeze Panes is already enabled.
2. Select the View tab.
3. Tap Freeze.
4. Select Unfreeze.
5. Scroll through the sheet and confirm that rows and columns move normally again.

Success Criteria

• Interface result: Previously fixed rows or columns no longer stay in place.
• What you can do next: You can set a different freeze method if needed.

Tips While Using

• Common mistake: If you do not open a worksheet that already has frozen panes, the change may not be obvious.