Copy-paste has always been one of the most frequently-used functions in excel. However, few people are aware of its true power. Today we will learn how to utilize Paste Special in excel.The first method is to paste special contents in your table.Take this table as an example. This table is set with styles. In many cases, we merely want to paste the values but don't want the original styles. What should we do? Press Ctrl+C to copy the contents, click the Paste drop-down menu in the ....

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

Appropriate transitions make slides more professional and attractive. So how can we set transitions when creating a Presentation document? Click the slide that we want to add transition animations, and click Transitions.WPS Office provides us with multiple slide transitions, such as Morph, Wipe, Push, Cube, Airplane and so on.Having selected the desired transition, click Effect Options to set the orientation and transition mode of the animation.We can apply it with one click. If we th....

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

In order to make the documents more fascinating, we will add effects to the text when we use WPS Writer to edit documents. So, how can we set the text effects? This video can help us to solve the problem and it can be also used in Microsoft Office Word and Openoffice. Take this document as an example, select the text content, click on the upper taskbar Home - and Text Effects. Here, we can add Wordart, Shadow, Reflection, Grow. When we insert a text box in the document and enter the te....

When we edit documents, insert project symbols into appropriate places that could highlight corresponding text contents. In this way, the text would be classified with structured classes. How can we insert project symbols in WPS text? Taking this document as an example, we can see that the difference in font size does not reflect the level of contents very well. If we want to emphasize the relationship between contents, how should we do it? 1. First, choose the corresponding text. 2. ....

When printing WPS Spreadsheet, in order to print out the table more readable and more beautiful, we can set up the printed page of the table. Take this table as an example. First, click the Page Layout tab and then click the Print Titles button to enter the Page Setup dialog box. If we want to print a specific part of the area, select the area that needs to be printed in the Print area box. If we want to print too much data, we can print them on several pages. Except for the first pag....