Download WPS Office for your device

When creating tables, we often need to insert check boxes to check the information quickly and check multiple options at once. Today we'll learn how to insert check boxes. Take this Registration of Selected Courses table as an example. 1. Go to the Insert tab, click the Forms drop-down button, and select the Check box. 2. The cursor becomes the shape of a cross, and you can insert a check box by dragging the mouse.3. Input text in the check box, such as "French."Then the check box ....

Today, let me introduce you to a lesser-used function, Manual Recalculation. Take this document as an example. Now, the cells have formulas. When we modify the source data, the values in the table will also change automatically. That is because the table turns on the automatic calculation by default. When we need to process a particularly large amount of data in the worksheet, if we still choose automatic calculation, then every time we change the source data, the table data processing....

Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell. In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them. If the position of the table changes, the inserted pictures will not fit in the new ce....

WPS Writer is easy to use as Microsoft Word. Both WPS Presentation and Microsoft PowerPoint have the Screenshot function. What is the difference between them? In Microsoft PowerPoint, two methods are available. One is Available Windows, which means taking screenshots through the opened windows on our desktop; the other is Screen Clipping, requiring us to manually capture the size of screenshots. In WPS Presentation, we can enter the Insert tab and click the Screenshot drop-down button.....

WPS Writer is easy to use as Microsoft Word. WPS and Microsoft Word both have the Split and Merge function, but what is the difference between them? We will use the same document to compare. For Microsoft Word, if we want to merge the file, head to the Insert tab, click the drop-down list at Object, select Text from File. Then select the files to be merged, and click OK.This method merges the whole document by default, and the scope of merging cannot be selected. If we want to split do....

How can we change the paper orientation and size for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice.