Application of Track Changes

When we need to highlight the changes of an article, we can apply this feature: Track Changes. · Track ChangesClick the Track Changes drop-down button in the Review tab, and select Track Changes to enter the Track Changes mode. Its shortcut key is Ctrl+Shift+E. Then when we add text to the paragraphs, the text automatically appears in red. When we delete text or change its style, there are corresponding records on the right.In simple terms, WPS Office automatically records and displays....

How can we insert endnotes for Documents

Endnotes usually appear at the end of the text and are mostly used to cite sources. When writing a paper, we often need to add endnotes to supplement the specific text. Then how can we insert an endnote for documents? · Step 1Place the mouse cursor where you want to insert the endnote. Click the References tab first, then click Settings, and finally click Footnote/(and)Endnote. · Step 2In the Footnote/(and)Endnote dialog box, we can set the Location according to our needs. As for this ....

How to use WPSArt in WPS Presentation

Are you still struggling to create a hierarchy like this one when you use WPS Presentation to make the company's annual report? Next, let's learn how to quickly create a hierarchy. Click the Insert tab and the WPSArt button to pop up the Insert WPSArt Dialog pane. Here, we can see the different types of Hierarchy. Click the graphic, and the corresponding application scenario description will be displayed on the right side.Click Hierarchy, and select one of the styles, finally c....

How to operate the action settings in WPS Presentation

The function of action settings in WPS Presentation allows us to set actions for graphic images and content text in slides. We will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. So, how can we use this function? Take the slides as an example. First, select the picture, click the Insert tab above, and then click Action Settings. There are two ways to trigger the action, namely mouse click and mouse over, we can choose an option according....

Format painter: tips for unifying format

In the process of making a WPS Presentation slide, we will unify the format of the text content for aesthetic purposes. Today, let's learn some tips for unifying the format quickly. Take this slide as an example. We can see that the font, font size, and color are different between each text. We can simply select the text box in the first line, and click the Home tab, then click the Format Painter button. Move the cursor to the second text box that needs a unified format, and click ....

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

Conditional Formatting for data virtualization

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

The SUMPRODUCT function for quick calculation of total sales

When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....