How to freeze panes in WPS Spreadsheet
A free Office suite fully compatible with Microsoft Office


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.
Also Read:
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences