How to freeze panes in WPS Spreadsheet

October 19, 2021
203 Views 0

Graphic skills

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 Home tab  and then click the Freeze Panes button.

3. Now click the first option in this drop down menu.

1.gif

 

· Freeze First Row

1. Use WPS Office to open the form and click the Home tab  and then click the Freeze Panes button.

2. Now click Freeze First Row.

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

2.gif

 

· Freeze First Column

1. Use WPS Office to open the form and click the Home tab  and then click the Freeze Panes button.

2. Now click Freeze First Column.

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

3.gif

 

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

4.gif

 

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