How to copy animation effects with the animation painter 

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

How to create a table with one click

Did you know that, when you are using WPS Spreadsheet, you can directly create a table in the original datasheet? The generated table comes with functions such as sorting, filtering, and setting styles, which can save us a lot of time for subsequent operations. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Here are the steps to create a table. Take the sales table in this article as an example. 1. Click the Table button in the Insert tab. (Notes: You can also use th....

How to fill cells with pure colors, gradient colors, and patterns

When using WPS Spreadsheet to write a statistical data report, we may want to emphasize the cell data. To do this, we can fill the cell with background color and pattern.Take this table as an example. 1. If we want to fill the B3:G3 cell with color, select this area first.2. Click the Home tab above.3. Then click Settings.4. And finally click Cells. Or we can use the shortcut key Ctrl+1 to open the Formats Cells dialog box. · Pure colorClick Patterns, then we can choose a pure color to....

How to enter a number starting with 0 in the Spreadsheet

The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

How to customize text shortcut keys

We can process and edit documents more quickly by flexibly using shortcut keys.Then, how can we customize shortcut keys in WPS Office？ First, click Menu and Options to enter the Customize Ribbon interface.You can see Keyboard shortcuts in the lower-left corner. Click Customize to take you to the custom settings dialog. Take Insert Picture as an example. Head to the Insert tab in the left categories, and then find Insert Picture in the corresponding commands on the right.You can see th....

Split the screen for data comparison

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

How to insert the symbol in WPS Presentation

When editing WPS presentation files, we will inevitably need to enter some symbols that cannot be directly entered through the keyboard. So, how can we insert the special symbols as needed? Take the slides as an example. To facilitate statistics, we want to tick the box after the tourist attractions we have already visited. Click where we want to insert the symbol, click the Insert tab and the Symbol drop-down button. Here, we can see Recently Used Symbols and Custom Symbols. These are....