Split the screen for data comparison

Uploaded time: November 10, 2021 Difficulty: Primary

Split the screen for data comparison

Split the screen for data comparison

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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.

_1.gif


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.

_2.gif


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.

_3.gif

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