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

        2508 results for how to mark duplicates in excel

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

        2508 results for how to mark duplicates in excel

        The Graffiti function used to mark in PDF

        The Graffiti function used to mark in PDF

        01:41

        The Graffiti function used to mark in PDF

        Do you know how to draw on a PDF file? Let's try the "Graffiti" function! It can make your notes on PDF more fancy. Open the PDF in WPS Office. Get into the "Comment" tab, and click "Graffiti". In its dropdown list, we can access quick settings of the ink mark, including line colour, opacity, and line width. We can also use the shortcut keys "Alt+R" to open the settings window.Supposed that you need to mark continuous content, follow these few steps. Click "Draw curve". Then, choos....

        PDF 6.3K views
        How to enter a number starting with 0 in the Spreadsheet

        How to enter a number starting with 0 in the Spreadsheet

        01:38

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

        Spreadsheet 17.2K views
        How to customize the font in WPS Writer

        How to customize the font in WPS Writer

        02:03

        How to customize the font in WPS Writer

        When using WPS Writer, how can we customize the font for a document? In the toolbar of Home, users can simply set the Font, the Size, etc. For advanced settings for font, click the drop-down button next to Menu, choose Format and Font, then you can see the interface for Font setting. You can also press the shortcut Ctrl+D to pop up the dialog. In this interface, we can change the settings for Latin text font and Asian text font, which include fonts, Font style and Size. You can also c....

        Writer 65.7K views
        How to create a Form in spreadsheet

        How to create a Form in spreadsheet

        01:26

        How to create a Form in spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

        Spreadsheet 13.1K views
        How to insert pictures in Document

        How to insert pictures in Document

        02:05

        How to insert pictures in Document

        When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

        Writer 36.7K views
        How to insert comments in WPS Presentation

        How to insert comments in WPS Presentation

        01:41

        How to insert comments in WPS Presentation

        When using WPS Presentation, we can use the Comment feature to help us check the suggestions more intuitively. Also, this feature will not affect or modify the original content of the file. So how can we insert comments? Take these slides as an example. If we want to insert a comment on the first slide, click the Review tab above, and then click New Comment. At this time, a comment editing box will pop up in the upper left corner of the slide. Here, we can enter the comment content. Us....

        Presentation 8.5K views
        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
        How to insert attachments in WPS presentation

        How to insert attachments in WPS presentation

        01:07

        How to insert attachments in WPS presentation

        When editing slides, to explain the content more specifically, we sometimes need to add related attachments to the slides. We can use the Insert Attachments feature to directly open the attached files in the slides to avoid switching pages frequently during a presentation. So how can we do that? Take this work report as an example. To better enumerate the work completed in August, we can insert the WPS Spreadsheet attachment in the slide.1. Click the Insert tab, then click the File Obj....

        Presentation 9.2K views
        Prev 1 2 3 ... 313 314 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