How to freeze panes in WPS Spreadsheet

October 19, 2021
6.9K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

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.