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

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

We often need to paint various Flowcharts in the office routine. In WPS Writer, we can make flowcharts easily with the Insert Shapes function.There are many kinds of flowcharts. Today, we will give an example to illustrate better. Step one, insert a drawing canvas.Click Insert, then click Shapes and select New Drawing Canvas to add one.A great benefit is that we can drag the canvas directly to move the flowchart.You can drag the position of the canvas only if the canvas is set to a te....

When we are editing a document, we want to check how many characters we have entered in total. Or if we want to check the number of words in the selected paragraph, we can use the word count function. It can quickly help us count the pages, words, etc. in the document. For all, easy your work with WPS office suite. Taking this document as an example, in the status information area on the status bar at the bottom of the interface, we can get general information about the word count, the....

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

Both WPS Presentation and Microsoft PowerPoint have the function of Convert to Word. What are the differences between them? In Microsoft PowerPoint1. We need to click File, click Export, and click Create Handouts. 2. Then select a desired page layout and other settings, such as Notes next to slides or Paste, and click OK. In WPS Presentation1. We only need to click the Tools tab and click Convert to Word Document.2. Multiple page layouts and slide ranges are selected in the Translate t....

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

Shapes inserted in slides could make a presentation more attractive. How can we insert shapes in a presentation document? First, click the Insert tab, and click the Shapes button. In the selection list, we can see that there are different categories, namely Lines, Rectangles, and Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners, Callouts, and an Action button. Here we take the shape of Heart, which could be found in the Basic Shapes drop-down list. Insert it by....