Download WPS Office for your device

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

When designing slides, adding the same animation to similar text or shape elements can effectively unify the overall style of the slides. Here is how we can quickly copy animation effects with the Animation Painter tool in WPS Presentation. Take this slide as an example. In this slide, except for the first image, no animation has been added to the rest of the images. At this time, we only need to select the first image and click the Animation Painter button under the Animation tab.Then....

When processing table data, we sometimes need to export the table as an image to send the table information to others for viewing.Take this table as an example. We need to export the contents in the table as an image to send to the leader for review. Head to the Tools tab, and click Export to Picture. The exported image defaults to Long picture, and the table will export All pages by default in the pop-up dialog. You can find that the preview interface on the right is incomplete. At th....

When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....

Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency. Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painter button, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells. Then how....

This lesson focuses on sharing common methods of merging and splitting files1. WPS Spreadsheet has 6 different merging methods, you can merge different worksheets into the same workbook, or merge different workbooks into the same workbook, and support the merging of worksheets with the same name. 2. “Merge range data” can select two regions and use the same value between them to find, just like a function, but more simple than a function. 3.WPS Spreadsheet has 3 different split methods....

When we are using WPS Document to edit documents, there is always a high frequency of using search and replace features. These features not only can help us locate content, and replace it with specified content but also can replace the format of the text. It saves us a lot of time when we are editing the document, and increases the efficiency of work. Take this document as an example, when we are reading, we may want to quickly know where the character named Bennet has appeared in the ....

When editing chemistry and mathematics data, we often use superscript or subscript to represent special symbols. Take this document as an example, m2 represents the square in the unit area. How can we set the number 2 as a superscript? Select the number 2. In the Home tab, click the Superscript button. Or we can use the shortcut key Ctrl+Shift+= to set the number as a superscript.Numbers in some chemical symbols need to be set as subscripts, such as O2, N2. Select the number 2 in O2. I....