WPS Freeze Panes on iOS FAQ

When using Freeze Panes, common questions usually involve cell selection, unfreezing, display behavior, and worksheet scope; this section includes 4 common questions and a 3-term glossary.

FAQ

Which cell should I select before freezing panes?

1. If you only want to keep the top row visible, select Freeze Top Row from the freeze menu.
2. If you only want to keep the first column visible, select Freeze First Column.
3. If you want a custom frozen area, place the cursor in the cell below and to the right of the area you want to keep visible, then select Freeze to Active Cell.

How do I unfreeze panes after turning them on?

1. Open the worksheet where panes are already frozen.
2. Go to the View tab.
3. Tap Freeze and select Unfreeze.

Does Freeze Panes affect filtering or editing?

1. Freeze Panes mainly changes how the current worksheet is displayed.
2. In normal use, you can still scroll, filter, and edit data.
3. If you want to adjust the visible area again, unfreeze first and then apply a new freeze setting.

Why is the frozen area different from what I expected?

1. Check which cell was selected before you applied the setting.
2. Freeze to the active cell keeps the rows above and the columns to the left of that cell visible.
3. If the result is not correct, unfreeze panes, select the correct cell, and try again.

Glossary