WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        1523 results for excel v

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

        1523 results for excel v

        How to convert Excel to PDF

        How to convert Excel to PDF

        02:50

        How to convert Excel to PDF

        PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

        Spreadsheet 30.2K views
        More features in Export to Picture

        More features in Export to Picture

        03:29

        More features in Export to Picture

        When sharing a document, if we do not want others to edit the document, we can take many measures to limit the document's editing. Here, I will introduce you to one of the ways: Export to Picture. Microsoft Word can not save the document as a picture format directly.But, we can still save the document to picture through more tedious procedures. First, press Ctrl+A to select the document content, and press Ctrl+C to copy the desired content. When we press Ctrl+V to paste the content....

        Writer 7.9K views
        Ctrl+E smart filling

        Ctrl+E smart filling

        02:50

        Ctrl+E smart filling

        After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

        Spreadsheet 22.9K 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 39.0K views
        TEXT formula in WPS Spreadsheet

        TEXT formula in WPS Spreadsheet

        03:09

        TEXT formula in WPS Spreadsheet

        The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

        Spreadsheet 23.4K views

        How to Fix Excel Formulas Showing as Text in Excel

        The Excel software sometimes doesn't show proper results. We will show you to fix the excel showing formula instead of the result.

        xls Spreadsheet 47.1K views

        How to copy value without formula in Excel?

        When you are working in excel Excel/Spreadsheet WPS, copying and pasting is frequently performed from one cell to another. Most people get confused and found very difficult to excel copy value not formula and paste in a cell. As when they copy data from a cell, it not only copies the content from that cell but also the format such as background color, font color and formula within it. While you only want to copy values not formula within it. However Using WPS excel/spreadsheet is very....

        xls Spreadsheet 73.6K views

        How to insert excel into word

        Main keyword: insert excel into word Know three easy ways to insert excel into word Creating a document in Excel implies that data will be processed, while documents in Word are for creating texts. Generally, they do not need each other, but sometimes it is essential to join both formats by insert excel into word. There are several ways to achieve this goal. All created so that you do not have certain limitations and that, in this way, your work or projects can be carried out more easi....

        doc Writer 7.4K views
        Prev 1 2 3 ... 190 191 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube