WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Split the screen for data comparison

Uploaded time: November 10, 2021 Difficulty Beginner

Split the screen for data comparison

Split the screen for data comparison

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.

When we meet a situation where a large amount of data in the table can not be completely displayed in the window, we still want to see the contents from different positions at the same time. To solve this, using the Split window is probably the best idea.

If you want to connect the total sales with Branch in a spreadsheet with massive data, dragging the slider bar back and forth is a necessary yet inconvenient step.

Click the View tab, select the E column, and click the Split window button. At this time, the table will be split into two copies on the left side of the E column.

We can drag the slider to the K column on the left. Clearly, we can tell which branch generates sales in the selected cell.

We can also select a certain cell in the E column. Click the Split window button, and the worksheet will be divided into four quadrants with two dividing lines on the top and left border of this cell.

Now, dragging the slider bar, checking the branch according to sales, or comparing other information within the table won't be a problem.

Click the Remove split button if you tend to the original window.

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