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

    431 results for how to copy only visible cells in excel

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

    431 results for how to copy only visible cells in excel

    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 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
    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
    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
    More features in Picture to Text

    More features in Picture to Text

    02:12

    More features in Picture to Text

    Both WPS Spreadsheets and Microsoft Excel have the function of Converting pictures to text. What are the differences between them? Microsoft Excel itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, OneNote. 1. Copy the picture and paste it into OneNote.2. Click Copy Text from Picture with the right mouse button3. Paste the text into Excel as needed. In WPS Spreadsheet, the OCR function allows us to convert pictures to....

    Spreadsheet views

    How to lock cells in Excel

    1. Go to the Review tab.2. The Lock Cell button is grayed out, which means that the entire sheet has been locked by default.3. Click the Protect Sheet button, then a dialog will pop up.4. In the Allow all users of this worksheet to area, Select locked cells and Select unlocked cells these two options have been checked by default. (Note: Other options can be checked as needed.)5. We enter password in the Password (optional) box, and click the OK button.6. In the pop-up Confirm Password ....

    Spreadsheet views
    How to link WPS Writer and Spreadsheet together

    How to link WPS Writer and Spreadsheet together

    02:26

    How to link WPS Writer and Spreadsheet together

    In today's lesson, we will learn how to use the "Paste link" function in reality.In the workplace, we need to use Word to regularly report our work to the leader.Taking this monthly report as an example, we will generally choose to count the data in Excel and then copy and paste the data table into Word. Suppose you repeat this process every month, which will be a waste of time and sometimes leads to typographical errors. So how can we improve efficiency?The correct operation shoul....

    Writer views
    Wrap text in a cell

    Wrap text in a cell

    00:53

    Wrap text in a cell

    When we edit a document, we only need to press the Enter key on the keyboard to wrap text. When we edit spreadsheets, we press the Enter key to edit the cells in the next line, then how can wen wrap text in a cell? This video could help to solve the problem of Wrap text in a cell and could be also used in Microsoft Office Excel and Openoffice. The first method is to use the shortcut key Alt + Enter ; we can wrap text in a cell as we need. The second method is to click the Home tab and ....

    Spreadsheet 0.4096 views
    Prev 123...5354 Next
    WPS Academy
    Products
    Partners