Download WPS Office for your device

The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....

We mainly study two methods of targeted search, Go to and Find, which are the same in objectives to find the desired cells, and different in search mechanism. Specifically speaking, Go to plays its role based on the cell's own attributes, such as constants, formulas, and blanks. While Find is more flexibly used to set some keywords and cell formats.In addition to exact search, we can use the two wildcards, * and ?, to apply the approximate lookup to the text.

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 the basic usage of the RANDBETWEEN function, which can be used to return a random integer between two specified numbers. This function is relatively simple. For example, if I want to randomly generate an integer between 1 and 100, I only need to enter = RANDBETWEEN(1,100) in the cell and press the Enter key. What should I do if I wa....

When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

Navigation Pane works like GPS in WPS Office, allowing users to find and locate text and adjust article structures more efficiently. 1. We need to open the Navigation Pane. Click the View tab, select Navigation Pane, and then it will appear on the left. 2. We can also click the Navigation Pane drop-down button and choose Move to Right according to our habits.There are four icons on the left, namely, Content, Section Navigation, Bookmark, and Find and Replace.· ContentHere is the table ....

When entering text in WPS Writer, we often need to add some unique icons in the text to visualize the content. You can join a WPS membership to download free icons from the vast icon library. Head to the Insert tab and click the Icon Library button. Here we have several options as Recommended, Business, Education, and other types of icons.You can choose an icon style you like, and click the desired icon to insert into the document quickly after entering the details page. If we need to....

Do you select words by simply holding down the left click and dragging the mouse to the desired position?Actually, many quick ways are available. Now let's learn about them one by one.· Click to select a line of words1. Move your cursor to the left of a line of words. 2. Left click to select the line of words.· Double click to select a paragraph1. Similarly, move your cursor to the left of a paragraph.2. Double left click to select the paragraph.Note that paragraphs are separated b....

In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....