How to use the Smart Split Columns feature

The Smart Split Columns feature of the WPS Spreadsheet can divide the table content into columns according to the table content in four ways.· Delimiter:Take this table as an example. If we look through the table carefully, we can find that although the cells contain a lot of data, the data are all separated by space. 1. Now click Text to Columns in the Data tab, and click Smart Split Columns.2. After a dialog box pops up, we can view the result of Smart Split Columns in the preview wi....

How to convert Excel to PDF

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

How to consolidate data in WPS Spreadsheet

In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

How to set a worksheet in WPS Spreadsheet

The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

How to hide slides in WPS Presentation

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

How to print the notes in PDF

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

How to insert shapes in a worksheet

We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

How to insert comments in WPS Presentation

When using WPS Presentation, we can use the Comment feature to help us check the suggestions more intuitively. Also, this feature will not affect or modify the original content of the file. So how can we insert comments? Take these slides as an example. If we want to insert a comment on the first slide, click the Review tab above, and then click New Comment. At this time, a comment editing box will pop up in the upper left corner of the slide. Here, we can enter the comment content. Us....