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

        2845 results for All

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

        2845 results for All

        How to change comment color in Word

        No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Today we will learn how to change comment color, which will make your comment more personalized.1. Open your document in WPS Writer.2. Head to the Review tab, and click New Comment to insert a comment. 3. To change its color, click the drop-down button at Track Changes > Track Changes Options. In the pop-up dialog, click the drop-down button at ....

        doc Writer 33.3K views

        How to Obtain Weekday Name from a Date in Excel (3 Easiest Ways)

        Excel is powerful spreadsheet software that is used for data analysis and management. Excel is a great tool, mainly because it has so many different functions that can be used to manipulate your data. But the best part is that you can use Excel spreadsheets to create automated processes. One of the most common tasks that people perform using Excel is the creation of a report that shows the day names for each week. This is commonly seen in some companies where employees take turns in re....

        xls Spreadsheet 33.2K views

        How to Copy and Paste Text from PDF to Word

        1. Open your document in WPS PDF, and select the text that you want to copy.2. You can right click the text and click Copy, or use its shortcut key Ctrl+C.3. Open your word document and paste it there. Its shortcut key is Ctrl+V.Note that the content in this PDF should be in the form of text, but not image. 3. To paste only the text without it original format, you can paste it by clicking Keep Text Only. To be office specialists, you could learn how to use WPS Office online in WPS Ac....

        pdf PDF 33.1K views

        OCR PDF: Unlocking New Possibilities for Scanned Documents

        In the digital age, PDF has become an irreplaceable document standard. However, traditional PDF features have limitations when dealing with scanned documents. Fortunately, the introduction of OCR PDF brings new hope, making scanned files searchable and editable.   Differences Between Scanned PDF and Regular PDFRegular PDFs are typically generated from electronic text, while scanned document PDFs result from scanning paper documents. This cause a problem: electronic text in regular PDFs....

        pdf PDF 33.1K views

        Print layout in Word 2016

        The presentation in a Word document is worth a lot since it meets all the necessary elements. The Word print layout is the document's view, and you can find it in the toolbar, in the "Print Icons" option. Here you have this print layout in the Word guide, which shows you how you can use them with ease. The print layout in word 2010 allows you to view all pages with margins and text positions. It is necessary to use this tool before printing your documents since you can see if it is in ....

        doc Writer 33.0K views

        How to record the screen in WPS Presentation

        1. Open the slides in WPS Presentation.2. Then click the Tools tab → and then click the Screen Recorder button.Then a Screen Recorder interface will pop up. If this is the first time we click this button, we may need to wait for a second to open it.Here, we can select Record Screen, Record window or Record webcam. Record Screen: Users can record full screen, selected region or fixed region of the computer' s screen.Record window: Screen Recorder will only record the locked APP wind....

        ppt Presentation 33.0K views

        How to align text left in WPS Writer

        · Option 11. Open the document we want to edit in WPS Writer.2. Select the needed text.3. Right-click to select Paragraph in the popup drop-down menu.4. In the popup Paragraph dialog box, select Indents and Spacing → and then choose alignment as Left in General.5. Finally, click OK. · Option 21. Open the document we want to edit in WPS Writer.2. Select the needed text.3. Click the Home tab → and then click the Align text Left button. Or we can use its shortcut key Ctrl+L. This skill co....

        doc Writer 32.9K views

        How to use the VLOOKUP function across multiple sheets in WPS Office Excel?

        In the following example, Sheet1 ‘Client Order List’ records the equipment types ordered by corresponding client company names, while Sheet2 ‘Price List’ lists Sequence No. and Price for each type of equipment. Now we want to fill in Column D ‘Price’ for each company, using the VLOOKUP function with data in Sheet2.Sheet1: Client Order List Sheet2: Price List · Option 1:1. Input =VLOOKUP(B2,'Price List'!$A$1:$C$11,3,FALSE) in cell C2 of Sheet1 ‘Client Order List’. 2. Select cell....

        xls Spreadsheet 32.8K views
        Prev 1 ... 74 75 ... 355 356 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