Download WPS Office for your device

In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables. In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer. If we need to print two copies of the spreadsheet document, we can chec....

When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

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

When making tables in word, we often need to set their accurate row height and column width. In this video, you'll learn how to adjust table row height and column width in word. · Row height:Select the table for settings. Next, get into the Table Tools tab and click Table Properties. Go to the Row tab of the pop-up dialog. Then, we can adjust the row height at Size. After checking the Specify height option, enter ’0.5’ in the input box. In the category of Row height is..., we can c....

In our daily work, we often need to split or merge worksheets.Most people use an easy way of copying and pasting, but it is a waste of time. In Microsoft Excel, we may need plug-ins, VBA or Power Query, etc., to split or merge workbooks.For convenience, WPS Spreadsheets provides the function of splitting and merging workbooks. First, let's learn about the splitting function. WPS Office provides three ways of splitting.· Split Sheets By ContentTake this workbook as an example, which....

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

We may encounter some errors when calculating in tables. One of these errors is "#NUM!." There are mainly three causes: 1. The calculated value is too large or too small. 2. Invalid values are referenced in the formula. 3. The iterative function fails to calculate the result. · 1. The calculated value is too large or too small.Take this table as an example. To calculate eight hundred to the power of nine hundred, input "=B3^C3," which means B3 to the power of C3. Then it returns "#NUM....

Merge Shapes is an important function in WPS Presentation. By using it skillfully, you can also create slides that have a strong sense of design.In short, based on the Boolean operation, Merge Shapes is the process of adding and subtracting two or more graphics. Select two or more graphics on the slide, and click the Drawing Tool tab and the Merge Shapes drop-down button.In the drop-down menu, we can see there are five options. They are Union, Combine, Fragment, Intersect and Subtract.....