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

Use Freeze Panes to freeze rows and columns

Uploaded time: February 24, 2022 Difficulty Beginner

Use Freeze Panes to freeze rows and columns

Use Freeze Panes to freeze rows and columns

When dealing with huge amounts of data, we find it difficult to view data and its corresponding headings at the same time. The Freeze Panes function can solve this problem.

Take this table as an example.

Click Tools, and in the View tab, select Freeze Panes.

Here we can see three options of Freeze Panes, namely, Top Row, First Column, and Current Cell.

If we want the heading row of this table to always be visible, choose Top Row.

Then we can scroll through the table with the heading row fixed.

And how can we disable this feature? Click Freeze Panes again.

If you want to view the column labels more expediently, choose First Column here.

Then we can scroll through the table with the first column fixed.

In addition to these, we can also freeze any cell range according to our actual needs.

Here are the steps:

1. Select cell B2 and click Current Cell to freeze it.

2. Then the cell range above the second row and that on the left of column B will be frozen.

It's more convenient to view and edit table data in WPS Office for PC. You're recommended to explore it.

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