WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

A table of contents, also called TOC, is a significant part of an article. It can help readers to get the outline quickly and locate the target part. In WPS, we can insert a table of contents in a convenient way. Click the blank page inserted at the beginning of the article. Get into the Reference tab, and click Table of Contents. In the dropdown menu, we can choose from three styles of the table of contents, which presents in different layouts. Since we have "Heading 1", "Heading 2", ....

Sometimes the paragraphs must be automatically numbered to make the text more logically acceptable.For example, we are typesetting the paper. And according to the typesetting requirements, the heading doesn't need to be numbered, while the body part does, and each numbering starts from 1. How can we operate?1. Let's number the body part first. Hold down the Ctrl key, and press the left mouse button to select discontinuous body parts. Then click Home and Numbering. We can see th....

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

When we edit a long article, we need to adjust the structure of the article. For example, we need to move parts of the content and quickly change the heading level. But, scrolling and searching page by page is time-consuming. At this point, we can switch to the outline view mode.Go to the View tab, and click the Outline button to switch to the outline view mode. First, I will show you what is displayed on the page in this view mode.1. In the ribbon above, we can adjust the level of the....

In the process of document typesetting, using the break feature correctly can help us effectively improve the readability and aesthetics of the document. We can use different types of Break in different situations. Here, we can use this paper to demonstrate the various usages of the break feature.· 1. Page BreakIf we want to place the content of the level 2 heading on a new page, we can insert a page break. Click the beginning of the level 2 heading, click the Breaks drop-down button i....

To facilitate reading, we will set the table of contents for the headings of contents in the long document. Do you know how to set the TOC level correctly? Take this document as an example. If we want to generate the table of contents, click Reference and then click Table of Contents. A blank table of contents is inserted, which is not what we want.GIf We need to set the table of contents for headings in the article. First, select the first bold heading in the article, click the Refere....