WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to copy visible cells only

    284 results for how to copy visible cells only

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF

    284 results for how to copy visible cells only

    How to copy animation effects with the animation painter 

    How to copy animation effects with the animation painter 

    01:23

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

    Presentation views
    How to clear content format and comments for cells

    How to clear content format and comments for cells

    01:43

    How to clear content format and comments for cells

    When we use the WPS Spreadsheet to work, we sometimes need to clear the content of the table quickly. How can we realize it? This video could help to solve this problem. Take this transcript as an example. 1. To clear all contents within the table, select the area that needs to be cleared.2. Click the Clear dropdown button in the Home tab, and choose the All option to clear the table as needed. (Notes: We can also use the Clear function in this step. To realize it, select the area, and....

    Spreadsheet views
    How to lock and unlock cells in WPS Spreadsheet

    How to lock and unlock cells in WPS Spreadsheet

    01:35

    How to lock and unlock cells in WPS Spreadsheet

    If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

    Spreadsheet 0.2183 views
    How to fill cells with pure colors, gradient colors, and patterns

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

    01:57

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

    Spreadsheet views
    Use format painter to adjust the styles in batches

    Use format painter to adjust the styles in batches

    01:28

    Use format painter to adjust the styles in batches

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

    Spreadsheet views
    Different methods of using format painter

    Different methods of using format painter

    02:12

    Different methods of using format painter

    When we use WPS Spreadsheet at work, if we want to quickly copy the formatting of a cell to another cell, we can use the Format Painter function in WPS Spreadsheet. Take this table as an example. We now want to copy and paste the formatting of cell A1 to cell D1. 1. Select cell A1.2. Click the Home tab first and then click the Format Painter button.3. Now select cell D1. There you can copy and paste the formatting of cell A1 to cell D1. But how can we use Format Painter to copy and pa....

    Spreadsheet 0.2794 views
    How to use the paste special function

    How to use the paste special function

    02:11

    How to use the paste special function

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

    Spreadsheet views
    Use formula to set the conditional formatting

    Use formula to set the conditional formatting

    01:28

    Use formula to set the conditional formatting

    Take this table as an example. We can use the formula to set the conditional formatting by ourselves and mark the finished projects. Select the cell range A2:C22, and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the New Rule option. In the pop-up dialog, we choose the Use a formula to determine which cells to format option.In the Format only cells with edit box, enter the formula "=$C2="Finished" ". The absolute reference has been added to the co....

    Spreadsheet views
    Prev 123...3536 Next
    WPS Academy
    Products
    Partners