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

        9 results for common uses

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

        9 results for common uses

        Five common uses of the Tab key

        Five common uses of the Tab key

        02:53

        Five common uses of the Tab key

        Do you know how to quickly indent the beginning of a paragraph, or start a numbering list, or select one of the overlapping layers? The Tab key will help you make it.Now I'll introduce you to five common uses of the Tab key.· IndentationWhen writing an article, a novice user usually indents the beginning of a paragraph by 4 characters by pressing the space key, but it's too troublesome.Actually, we only need to press the Tab key, and it will be indented by four characters autom....

        Writer 29.5K views
        Why error message #VALUE! occurs and how to solve it

        Why error message #VALUE! occurs and how to solve it

        03:11

        Why error message #VALUE! occurs and how to solve it

        The errors in a function or formula will result in calculation errors, and it returns "#VALUE!". The common causes are as follows: incorrect function syntax, the reference cells containing text in the formulas, the reference cells containing a non-character string in the formulas, and the lack of braces in the formulas. Let's go through them one by one. · Incorrect function syntax.For example, we want to calculate the difference in computer sales between the first half of this year....

        Spreadsheet 15.6K views
        Why error message #REF! occurs and how to solve it

        Why error message #REF! occurs and how to solve it

        03:18

        Why error message #REF! occurs and how to solve it

        The error message "#REF" is common in table calculations. In general, there are mainly two causes. First, the referenced cells in the formula are deleted or replaced by other cells. Second, the formula references invalid cell ranges or values. Then how can we solve these problems? · The referenced cells in the formula are deleted or replaced by other cells.o The referenced cells in the formula are deleted.Take this table as an example. 1. To calculate the total sales of computers t....

        Spreadsheet 10.7K views
        How to merge and split files

        How to merge and split files

        08:21

        How to merge and split files

        This lesson focuses on sharing common methods of merging and splitting files1. WPS Spreadsheet has 6 different merging methods, you can merge different worksheets into the same workbook, or merge different workbooks into the same workbook, and support the merging of worksheets with the same name. 2. “Merge range data” can select two regions and use the same value between them to find, just like a function, but more simple than a function. 3.WPS Spreadsheet has 3 different split methods....

        Spreadsheet 19.1K views
        Why error message NA occurs and how to solve it

        Why error message NA occurs and how to solve it

        02:56

        Why error message NA occurs and how to solve it

        When using the VLOOKUP function to locate data, a #N/A error sometimes will appear.Two common causes are listed as followed. The first reason: the searched value is not in the searching range. Take this table as an example. To get the sales of erasers, black pens, pencils, and blue pens, we need to insert the following formula: =VLOOKUP(F3,A2:D9,4,0) F3 is Lookup_value, Eraser is the value to look for. A2:D9 is Table_array, the entire table is the range containing the data to look for.....

        Spreadsheet 13.1K views
        Batch export multiple pictures

        Batch export multiple pictures

        00:54

        Batch export multiple pictures

        If you want to save multiple pictures in a table, a common practice is to save them one by one. It will be very troublesome when there are a large number of pictures. Today, we will learn a quick tip to export pictures in batches. Taking this table as an example, we can see that there are many pictures in the table. First, change the suffix name of this table file in accordance with the suffix of the zip file. Here, we change the .xlsx format to .rar format and then decompress the file....

        Spreadsheet 10.6K views
        How to create a resume for work in WPS Writer

        How to create a resume for work in WPS Writer

        05:08

        How to create a resume for work in WPS Writer

        Graduation season is coming. Do you know how to create a professional resume for a job like this? Now we'll introduce you to how to create a resume in WPS Writer step by step. l Step 1. Set the page size.In this blank document, we need to set the page size and margin in advance. Click the Page Layout tab, select the common size of a resume, A4, and set Margins as the built-in Narrow.l Step 2. Arrange the overall layout with ShapesThe resume should be clean and concise with fewer f....

        Writer 19.8K views
        Look up data quickly with LOOKUP function

        Look up data quickly with LOOKUP function

        04:23

        Look up data quickly with LOOKUP function

        Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....

        Spreadsheet 24.8K views
        Prev 1 2 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