How can we freeze the pane in WPS Spreadsheet

Uploaded time: 2021-08-27 Difficulty: Primary

How can we freeze the pane in WPS Spreadsheet

How can we freeze the pane in WPS Spreadsheet

Graphic skills

When viewing a worksheet with a large amounts of data in the WPS Spreadsheet, we can't see the title row if we drag the scroll bar. Therefore, we won't be able to know exactly what each column of data represents. So how can we freeze a row or column for us to check it more conveniently?

 

Today I'm going to introduce you to a practical feature, Freeze Panes. Take this table as an example. Click the Home tab, then click the Freeze Panes button. You can see that there are three options. The first is Custom Freeze, the second is Freeze Top Row, and the third is Freeze First Column.

 

Let's look at Freeze Top Row first.

1. Click Freeze Top Row, then the top row of the table will be frozen. 

WPS_01.gif


2. If we want to unfreeze, just click Freeze Panes again, and click Unfreeze Panes. TheFreeze First Column feature works in the same way. Just select Freeze the first column, and then the first column of the table will be frozen.

WPS_2.gif

 

So what should we do to freeze other rows and columns?

1. If we want to freeze a row, we first need to select the row below it and then do the settings. 

2. For example, we now need to freeze the two rows A1, A2, then we need to select the A3 cell and click Freeze Panes. Now the first option becomes Freeze to row 2.

3. Click Freeze to row 2, then drag the scroll bar.

We will find that the first two rows are frozen now and will not be covered by other rows.

WPS_3.gif

 

Now, what if we want to freeze a row and a column at the same time ?

For example, we want to freeze row A2 and column A at the same time.

1. First, we need to find the intersecting cells of the next row and the next column, the intersecting cells of row A3 and column B.

2. Click cell B3 and click Freeze Panes. Then the first option will change to Freeze to row 2 column A.

3. Now just click it and complete the settings.

Combining this feature with Reading Layout, can make it easier for us to view data. If you want to learn more about using Reading Layout, you can watch more related videos in our WPS Academy.

WPS_4.gif

 

These are the introductions on the function and method of Freeze Panes.  Easy your work with WPS Spreadsheet like Microsoft Excel. Did you get it?