Download WPS Office for your device

In WPS Spreadsheet, there are many ways to merge worksheets. Do you know how to merge worksheets of the same name correctly?Take this workbook as an example, and you can find three worksheets that record students' scores in mathematics, physics, and chemistry respectively.Teachers need to extract the scores of mathematics, physics, and chemistry from these three classes and then put the scores of each subject in different workbooks. What can we do? First, click the Data tab, click ....

When printing tables in WPS Spreadsheet, to preview, we need to set the paper size first. So how can we set the paper size?First, click the Page Layout tab above, and then click Size. WPS Spreadsheet has already provided us with a variety of paper sizes. We can click to preview.If we need to adjust more settings for the paper size, we can click More Page Sizes. In the popup Page Setup dialog box, we can set Page Size and Print Quality according to different printers. In general, the hi....

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

WPS Presentation includes advanced animation, slide transitions, and support for video, images, audio, and even Flash. We usually drag the mouse to adjust the size and position of the inserted picture in the presentation.This is a convenient yet inaccurate method. Today we will learn a method to adjust the size and position of the picture accurately. Right-click the picture to be adjusted, then click Format Object.In the task pane that pops up on the right side of the screen, click SIZ....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn the basic usage of the RANDBETWEEN function, which can be used to return a random integer between two specified numbers. This function is relatively simple. For example, if I want to randomly generate an integer between 1 and 100, I only need to enter = RANDBETWEEN(1,100) in the cell and press the Enter key. What should I do if I wa....

Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....

Plain charts in a word file may fail to attract viewers. Subscribe to WPS Template membership, and you will be free to download beautiful charts from the vast library of charts to enhance the design and appeal of your charts. Click the Insert tab, click the Chart library button, and you are provided with diverse chart types like Column, Line, Pie, etc. You can choose a preferred type, and on the detail page, choose the desired chart to insert into the document quickly. If we need to ....

The main knowledge points of this lesson are the following 3 points1. Smart Split Columns can identify the contents and split them. There are four techniques for splitting columns based on text features: Delimiter, Text Type, Keyword, and Fixed Width. 2. Data formats can be standardized in addition to splitting columns. For example, numerical dates can be standardized dates, and numerical formats can be turned into text formats. 3. Ampersand operator and smart filling(Ctrl+E) can merg....