WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches
        Related: wps downloadwps for windowswps for macwps linux download
        Official downloads for every device

        Download WPS Office for your device

        Choose Windows, Mac, Linux, Chromebook, Android, or iOS.

        Free for personal use Cross-platform Microsoft Office compatible
        Download WPS for Windows .exe installer · 64-bit Download WPS for Mac .dmg installer · macOS
        Need a hand? View setup guide
        WPS Office official logo

        Download WPS Office for All Platforms

        Find your device and get the right version

        Compare All Versions

        Windows

        Windows 10/11
        64-bit

        Download .exe

        Mac

        macOS 10.12+

        Download .dmg

        Linux

        Debian / Ubuntu
        64-bit

        Download .deb

        Chromebook

        ChromeOS

        Use Linux Version

        Android

        Android 5.0+

        Google Play

        iOS

        iOS 12.0+

        App Store
        New to WPS Office? 3-step Setup Guide
        1. Choose your platform
        2. Download WPS
        3. Install and launch

        Search Results

        2403 results for how to mark duplicates in excel

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

        2403 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 11.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 25.8K 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 41.9K 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 88.5K 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 18.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 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 51.4K views
        More features in Remove Duplicates

        More features in Remove Duplicates

        03:14

        More features in Remove Duplicates

        To remove the duplicate data when dealing with tabular data, we can use the function of Remove Duplicates. In Microsoft, we can select the needed cell range and click the Remove Duplicates button in the Data tab to remove them. In WPS Spreadsheets, in addition to removing duplicates, we can also mark them for further review and collation.1. Click the Data tab, click the Highlight Duplicates drop-down button, and select Set. 2. Then select the cell range that needs to be marked and clic....

        Spreadsheet 17.3K views
        Prev 1 2 3 ... 300 301 Next
        WPS Office
        Join 600M+ Users Worldwide Free · Powerful · Cross-Platform Office Suite
        Download WPS Office

        Quick Links

        • All Download Pages Choose your platform
        • Version Comparison Compare features
        • System Requirements Check compatibility
        • Installation Help Step-by-step guides

        WPS Office FAQ

        Which WPS Office version should I download?

        Choose the platform that matches the device where you want to install WPS Office.

        Can WPS Office open Microsoft Office files?

        Yes. WPS Office supports common document, spreadsheet, presentation, and PDF workflows.

        Popular Searches

        wps downloadwps for windowswps for macwps linux download

        Why choose WPS Office?

        • Lightweight & Fast
        • Compatible with Microsoft Office
        • Works Offline
        • Cross-Platform
        • Trusted by 600M+ Users
        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