WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to freeze panes in WPS Spreadsheet

October 19, 2021
17.1K Views

We can freeze the panes in three different ways.

· Freeze to

1. Select the cell below the rows and to the right of the columns that we want to freeze when scrolling.

2. Click the Hometab and then click the Freeze Panesbutton.

3. Now click thefirst option in this drop down menu.

· Freeze First Row

1. Use WPS Office to open the form and click the Hometab and then click the Freeze Panesbutton.

2. Now click Freeze First Row.

Then we can easily freeze the first row of this table.

· Freeze First Column

1. Use WPS Office to open the form and click the Hometab and then click the Freeze Panesbutton.

2. Now click Freeze First Column.

Then we can easily freeze the first column of this table.

Also, if we want to unfreeze panes, just click the Freeze Panes button in the View tab → select unfreeze panes.

This skill could also be used in Microsoft Office Excel and OpenOffice.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.