Get WPS Office for Windows

When giving a speech, we often need background music to set off the atmosphere. So how do we insert audio when making slides? Take this slide as an example, click the Insert tab above, and then click Audio. Here we can see Insert Audio, Link to Sound, Background Music and Link Background Music these four options. The difference between Audio and Background Music is that when we choose the Audio option, we can only hear the music when we play the slideshow where the music is inserted. B....

A slide with large information contains a large number of elements. Therefore, we are likely to make some mistakes when editing slides. The Select feature in WPS Presentation can help us avoid mistakes. Take this document as an example. Click the Home tab and click the Select drop-down button. Here we can see three options: Select All, Select Audio, and Select Pane. Then we will get to know them one by one. · Select All1. Click the Select drop-down button and click Select All to select....

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

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

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. When we meet a situation where a large amount of data in the table can not be completely displayed in the window, we still want to see the contents from different positions at the same time. To solve this, using the Split window is probably the best idea. If you want to connect the total sales with Branch in a spreadsheet with massive data, dragging the....

COUNTIF is a statistical function. It is often used to count the number of cells that meet the criteria. This function can not only count numbers and text but also can count expressions. So how can we use this function? The grammatical structure of the COUNTIF function is: COUNTIF(Range, Criteria)Range is the cell range that meets the criteria.Criteria are the conditions that need to be counted.Now we have a table that records everyone's afternoon tea order information. Column B co....

When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

How can we change the paper orientation and size for printing in WPS Writer? This video can help us and it can be also used in Microsoft Office Word and Openoffice.