The inserted text in a table may be limited by cells. At this time, the text box can become your first choice to beautify your texts. It is rather simple to insert a text box. Click the Insert tab, then select the Text Box drop-down button.You can choose Horizontal Text Box and Vertical Text Box, and the difference lies in the arrangement direction for text. You can benefit from two sides.First, the text box can be dragged at your will. For example, there are multiple paragraphs of tex....

Do you know how we can convert a number into the fraction format?There are two available methods to set fraction format in WPS Spreadsheet. First, select the range of the table, head to the Home tab, find the setting button in the shortcut menu, and set the Fraction format.Alternatively, we can select the desired range of cells, and right-click Format cells, whose shortcut key is Ctrl+1.Locate Fraction in the category list, and choose from different types of fractions in the Type area....

Do you know how to quickly indent the beginning of a paragraph, or start a numbering list, or select one of the overlapping layers? The Tab key will help you make it.Now I'll introduce you to five common uses of the Tab key.· IndentationWhen writing an article, a novice user usually indents the beginning of a paragraph by 4 characters by pressing the space key, but it's too troublesome.Actually, we only need to press the Tab key, and it will be indented by four characters autom....

In this lesson, we learned about the basic use of line and area charts.1.A line chart and an area chart are essentially identical. Both may effectively display data trends over a specific time period, but an area chart is better for displaying the stacked effect.2.The combo of a line chart and an area chart can diversify the data. The right color scheme can make the chart more advanced.3.In the same chart, a combo of line and column charts can display two sets of data with different di....

After we have entered the data, we need to make some basic content layout adjustments to make our table look clearer and more beautiful.How should we do it? Next, I'm going to do this in five steps. · 1. Add serial numberThe first column of a table usually adds a serial number to make the contents of the table easier to see. Take this table as an example. Select column A, right-click, choose the Insert option to insert a new column in front of the selected column and enter Serial n....

When we edit documents, insert project symbols into appropriate places that could highlight corresponding text contents. In this way, the text would be classified with structured classes. How can we insert project symbols in WPS text? Taking this document as an example, we can see that the difference in font size does not reflect the level of contents very well. If we want to emphasize the relationship between contents, how should we do it? 1. First, choose the corresponding text. 2. ....

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

This video introduces the basic editing operations of the table, mainly including data input in alternate rows and columns, the insertion, deletion, hiding and unhiding of rows and columns. Many beginners use the mouse to click on a cell and then enter the content when entering data. Here is a quick way to teach you how to do this. After entering the first data, press the Enter key to input data in alternate rows. Press the Tab key to input data in alternate columns. We can also click ....