The main knowledge points of this lesson are the following 4 points。1. We can use the Freeze Pane, Eye Protection, and Reading Layout functions when processing tables with large data. 2. To view multiple worksheets in the same workbook simultaneously, we can use the New Window and View Side by Side functions or use the Split window function to work with multiple windows without interference. 3. To compare data, we can use the View Side by Side function, but it's easier and more con....

When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

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....

When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

We may add notes to important content when reading a PDF document. Do you know how to print them out?Take this document as an example. We have added several notes on the page. 1. Click Menu and click Print.2. On the right of the pop-up dialog, select Document and Note Contents in the "Print content" drop-down button.3. Then the marks of notes are displayed in the preview window. However, we still fail to print out the contents in the text boxes. What can we do? There are two methods fo....

When adjusting the page layout of a word document, we can add page borders and change their styles. In this example, if we want to insert page borders of the palm tree style, how can we realize it? First, click the Page Layout tab, and choose Page Borders to pop up the Borders and Shading window. Here we can access the settings of the page borders, including style, color, and width. We can see the page border of palm trees in the category of Art. In the Preview interface, we can choose....