Download WPS Office for your device

All users may need to show or hide editing marks to preview the editing effects or make the document look neater. Today we are going to learn about how to show or hide editing marks. · Show/Hide paragraph marksTake this document as an example. Every time we press the Enter key, a black Paragraph Mark appears, which is also called Hard Return. In general, it appears at the end of a paragraph, and its code is "^p" in a Word document.It doesn't affect printing but sometimes has a nega....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to format the time. Before setting, we need to be aware of the correct way to record time.A complete-time duration consists of hours, minutes and seconds, and each value is separated by colons.For example: 12:25:25. Take this table as an example, select the cells A4-A14. Click the Number Format drop-down button in the Home tab, ....

Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....

It is very important to limit the length of your speech in some speech contests or formal speech occasions. WPS Presentation provides the Rehearse Timings feature for us to rehearse the speech. Take this slide as an example. 1. Head to the Slide Show tab, and click the Rehearse Timings button to enter the rehearse mode. In the upper left corner, there is a timer that can be moved freely. 2. Click the inverted triangle icon on the left or click to jump to the next slide, and then the sl....

In this lesson, we have learned several ways to set conditional formatting. 1."Highlight Cells Rules" and "Top/Bottom Rules." They can highlight cells quickly and draw people's attention to data that matches the conditions. 2.Data bar, Color Scales and Icon Sets can visualize data and make them clearer to recognize. 3.We also learn how to add multiple formatting to data using the AND function.In the selected area, we can set multiple conditions, delete specific rules or clear all ....

Do you know how to virtualize data with the Conditional Formatting function? The worksheet presents the data of 'Likes to views ratios'. Today's tutorial will take this sheet as an example for data virtualising. Select the cell range B2:B10. Go to Home and click Conditional Formatting. Next, choose Data Bars and then the red Gradient Fill option. After that, we can see the data virtualized with red bars.Although the data in cell B13 is 66.42%, as we can see, the data bar fi....

Take this table as an example. When creating a table, we often need to use the Slash Header to display the title name, so how can we make a Slash Header?1. Select cell A1, right-click.2. Then select Format Cells in the popup shortcut menu. We can also use the shortcut key Ctrl+1.3. Then select Border in the Format Cells dialog box.4. Now select the slash shape icon in the border preview area, and click OK. 5. Now enter Subject in cell A1.6. Press Alt+Enter to insert a line break, and t....

The Conditional Formatting function can format the cells fulfiling specific conditions. With this function, we can quickly compare data in a worksheet. The worksheet in this example records the performance of staff. What if we want to highlight the Top Three performances? When there is a large amount of data, Conditional Formatting can quickly filter the first three maximums. 1. Select cell C2. 2. Then, press Ctrl + Shift + DOWN (↓) for quick selection from cell C2 to C26 (C2:C26).3. G....