Download WPS Office for your device

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

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

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