Download WPS Office for your device

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

WPS Writer's draw table feature allows us to use the mouse to draw custom tables directly in the document. So, how can we do it? Click this table in the document. Click the Table Tools and the Draw Table button, and then the mouse cursor will become a brush, then we can draw tables in the document as needed. If we now want to draw a 3X4 table, hold down the left button on the mouse. At this point, the table dotted lines will appear on the page, and a floating window will appear in ....

When processing table data, we sometimes need to export the table as an image to send the table information to others for viewing.Take this table as an example. We need to export the contents in the table as an image to send to the leader for review. Head to the Tools tab, and click Export to Picture. The exported image defaults to Long picture, and the table will export All pages by default in the pop-up dialog. You can find that the preview interface on the right is incomplete. At th....

A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....

If we want to insert text anywhere in the document, we can use a text box to finish it. The text box is divided into two types: horizontal text box and vertical text box. · Horizontal Text Box:Get into the Insert tab, click the Text Box drop-down button and choose Horizontal Text Box. When we return to the editing page, we will find that the cursor has turned into a cross shape. Then we can draw the text box where we want to insert the text. If we enter too much text beyond the visible....

When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....

The line chart is mainly used to show the trends in data and is also one of the most commonly used chart styles at work. This table shows the number of newly hired employees and the number of employees who resigned from the company from 2000 to 2021. So how can we quickly generate a line chart on this? 1. Select all the data in column B. 2. Click the Chart button in the Insert tab, and choose the Line option. In this way, we can get a simple line chart.If we modify the data in the data....

Do you know how to make an ordinary line chart more special? Today we are going to show you how to make a line chart with fill effects, that is, an area chart.Take this table as an example. This is the dynamic price-earnings ratio data of a certain country over a period of time. It is difficult for us to see the difference between the data. Therefore, we need to use an area chart to show the changes in the dynamic price-earnings ratio index.1. First, we click the Insert tab.2. Click th....