We often need use the Split Book function so that we can split a workbook into multiple files at work. Take this workbook as an example, which is a table of goods sales from January to September. Now we want to split it into three workbook files. 1. Head to the Home tab, click the Split Sheet drop-down button，and select Split Book.2. In the pop-up dialog, the current file is checked by default, and you can also split other files by clicking Add more files.3. When finished, click Next t....

When calculating data with WPS Spreadsheet, the error message #DIV/0! will come to us from time to time.What caused the mistake? And how can we remove it? Take this table as an example. For example, when we want to calculate the unit price of pencils, we can enter =C3/D3 in cell E3, and the calculation result will show the error value #DIV/0! This is because, in this division operation, the denominator is 0, which leads to the calculation error. When we drop down and fill in the calcul....

When doing a presentation, how can we hide certain slides during the slide show while keeping them in the document? This video will show you the Hide Slide function in WPS Presentation. Suppose that we need to hide the second slide, select the preview of it, get into the Slide Show tab, and click Hide Slide. Then we can see the corresponding slide preview greyed out, with a Hide slide icon presenting on the upper-left corner of it. In this way, when we click From Current Slide to start....

Do you know how to split your worksheet?Take this table as an example. Seeing the sales performance from January to July, we need to split the monthly sales into individual workbooks and send them to the leader. It is too cumbersome to copy and paste the data one by one and generate new files. Fortunately, we can use the function of Split Books by Sheet. In this table, we click the Data tab, then click the Split Sheet drop-down button, and select Split Books By Sheet in the drop-down m....

In the last video, we just talked about the worksheet and workbook in the WPS Spreadsheet. So in this video, we will learn about the Spreadsheet interface elements: rows, columns, cells, and those tools in the lower status bar.On the left is the row, and the marked numbers 1, 2, and 3 are called the row number. Above is the column, and the marked numbers A, B, and C are called the column number. The grids in the middle are called cells.When expressing the position of a cell, we use col....

This lesson focuses on sharing common methods of merging and splitting files1. WPS Spreadsheet has 6 different merging methods, you can merge different worksheets into the same workbook, or merge different workbooks into the same workbook, and support the merging of worksheets with the same name. 2. “Merge range data” can select two regions and use the same value between them to find, just like a function, but more simple than a function. 3.WPS Spreadsheet has 3 different split methods....

When we are editing a PDF file, what should we do if we want to extract and replace several pages of the content?We can use the Extract Page and Replace pages functions of WPS Premium. If we want to extract the third page of this file and save it separately as a PDF file, click the Page tab, click Extract Page. In the Extract Mode box, select Extract selected page to PDF. In Page range, enter 3.We can add a watermark to the file, and we can also name the newly output file and set the s....