- All Tutorials
- Video Tutorials
- Quick Tutorials

- All
- Spreadsheet
- Presentation
- Writer

640 Search results

#### How to set the line numbers in WPS Writer

01:56### How to set the line numbers in WPS Writer

The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

#### How to use the Excel MID function

01:54### How to use the Excel MID function

When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

#### How to convert numbers into percentages

01:08### How to convert numbers into percentages

We can directly know the relationships between the part and the whole in our daily work with statistical values shown as percentages. Take this table as an example. We want to calculate the percentage of January sales in annual sales so that we can apply the percentage format here.First, select the cell D2 and enter the formula “=B2/C2”. Then use the fill handle to pull down, and we can get the sales of each employee in January of this year. Then we select the cells D2-D15. Click the N....

#### Use the ROW function in WPS Spreadsheets for row numbering

03:03### Use the ROW function in WPS Spreadsheets for row numbering

When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....

#### How to enter a number starting with 0 in the Spreadsheet

01:38### How to enter a number starting with 0 in the Spreadsheet

The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

#### How can we insert page number into a Document

01:37### How can we insert page number into a Document

In the process of document typesetting, adding page numbers can help us quickly retrieve and locate. So, how can we insert the page number into a document? Take this document as an example. Click the Insert tab first, then click the Page Number drop-down button. In the Built-in Style, we can choose the style according to demand. If there is no suitable page style, we can click the Insert Page Number button to set up. In the pop-up Insert Page Number dialog box interface, we can set the....

#### Format cells

04:42### Format cells

Cell formatting is very important in data processing. We often need to set a proper cell format when entering data in WPS Spreadsheet. Let's talk about the differences between each format. Take this table as an example. Most of the cells in column B of the table are in general format. General format cells have no specific number format, which are simply displayed as numbers. In this table, most of the Column B cells are in general format. The format of cell C2 is a numeric format.....

#### Insert Table of Figures and refer to the List of Captioned Objects

01:20### Insert Table of Figures and refer to the List of Captioned Objects

When there are too many pictures or tables inserted into a document, we can make a table of figures. It can generate a list of captioned objects and their page numbers for quick location. So how do we insert the table of figures? In this document, for example, we have inserted 6 images with captions.Click the location where we need to insert the table of figures, and click the Insert Table of Figures button on the References tab to get a dialog. On the left side of the dialog, we can ....