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

        452 results for show tick mark in excel

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

        452 results for show tick mark 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 10.4K views
        Use the ROW function to mark the row number

        Use the ROW function to mark the row number

        02:04

        Use the ROW function to mark the row number

        When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....

        Spreadsheet 19.5K views
        Show or hide editing marks

        Show or hide editing marks

        02:27

        Show or hide editing marks

        All users may need to show or hide editing marks to preview the editing effects or make the document look neater. Today we are going to learn about how to show or hide editing marks. · Show/Hide paragraph marksTake this document as an example. Every time we press the Enter key, a black Paragraph Mark appears, which is also called Hard Return. In general, it appears at the end of a paragraph, and its code is "^p" in a Word document.It doesn't affect printing but sometimes has a nega....

        Writer 18.1K views
        Customize the formats to show data changes

        Customize the formats to show data changes

        01:28

        Customize the formats to show data changes

        Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....

        Spreadsheet 12.7K views
        The Rehearse Timings feature of Slide Show

        The Rehearse Timings feature of Slide Show

        01:21

        The Rehearse Timings feature of Slide Show

        It is very important to limit the length of your speech in some speech contests or formal speech occasions. WPS Presentation provides the Rehearse Timings feature for us to rehearse the speech. Take this slide as an example. 1. Head to the Slide Show tab, and click the Rehearse Timings button to enter the rehearse mode. In the upper left corner, there is a timer that can be moved freely. 2. Click the inverted triangle icon on the left or click to jump to the next slide, and then the sl....

        Presentation 12.1K views
        Use slash header to show the title name

        Use slash header to show the title name

        01:25

        Use slash header to show the title name

        Take this table as an example. When creating a table, we often need to use the Slash Header to display the title name, so how can we make a Slash Header?1. Select cell A1, right-click.2. Then select Format Cells in the popup shortcut menu. We can also use the shortcut key Ctrl+1.3. Then select Border in the Format Cells dialog box.4. Now select the slash shape icon in the border preview area, and click OK. 5. Now enter Subject in cell A1.6. Press Alt+Enter to insert a line break, and t....

        Spreadsheet 10.6K views
        The annotation function in presenting slides

        The annotation function in presenting slides

        02:58

        The annotation function in presenting slides

        If you are a teacher and need to mark your slides when presenting them in lectures, then the annotation function in WPS Presentation is perfect for you. If we place the mouse in the lower left corner when presenting slides, the shortcut menu will appear.The first two icons are used to switch slides, while the next three icons respectively correspond to the brush tool, focus and zoom tool, and other auxiliary tools. By default, we can click on the slide page to switch to the next slide....

        Presentation 17.0K views
        How to use the Spell Check function in WPS Spreadsheet

        How to use the Spell Check function in WPS Spreadsheet

        02:15

        How to use the Spell Check function in WPS Spreadsheet

        The Spell Check function of WPS Spreadsheet can help us quickly trap misspelled words and provide suggestions for correction, greatly saving the calibration time of the table.In the Review tab, click the Spell Check button and open the Spell Check dialog box, whose shortcut key is F7.In the text box on the left, we can see some words marked in red. These are the words in which WPS Office has detected possible spelling mistakes. Take this table as an example. The cells are checked from ....

        Spreadsheet 18.0K views
        Prev 1 2 3 ... 56 57 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