WPS Academy
  • Home
  • Video Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Data Visualization Page Layout Review and Security More Functions and Formulas
    WPS Writer Text Writing Insert and Edit Page Layout Review and Security References More
    WPS Presentation View Insert and Edit Animation and Slide Show More Review and Security
    WPS PDF Multiple Editing Tools Insert More Add Comments Page Management File Format Conversion Print
  • Graphic Tutorials
    WPS Spreadsheet Data Entry and Editing Data Analysis Functions and Formulas Page Layout Review and Security More
    WPS Writer Text Writing Insert and Edit References Page Layout Review and Comments Security More
    WPS Presentation Insert and Edit Animation and Slide Show Premium Benefits More
    PDF Edit View Review and Comments Security Premium Benefits More
    WPS Basics Home Page Settings and Account Premium Benefits More
    Beginner Tutorial Preferences Settings Get Started Common Uses
  • Download
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
Top Searches
    Login/Sign up
    Login/Sign up

    • Home
    • Video Tutorials
    • Graphic Tutorials
    • Home
    • Popular
    • how to change excel language windows 10

    125 results for how to change excel language windows 10

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

    125 results for how to change excel language windows 10

    How to calculate top 10 in WPS Office Excel

    In this article, you will know how to calculate top 10 in excel with simple steps as following: Here we take a scholarship table as an example. Suppose we want to calculate the top 10 scholarships. · Find out the top 10 values in WPS SpreadsheetHere are two methods to find out the top 10 values in WPS Spreadsheet.o Method 1: We can use the Conditional Formatting function to highlight the top 10 values.1. Select the cell range, click the Conditional Formatting drop-down button in the H....

    Spreadsheet views

    How to change case in Excel

    There are three relevant functions can help a lot. Here we take a name table as an example.1. UPPER functionWe can use this function to convert the whole word to upper case. Enter the formula “=UPPER(A2)”, and drag the mouse to fill the following cells. 2. LOWER functionWe can use this function to convert the whole word to lower case. Enter the formula “=LOWER(B2)”, and drag the mouse to fill the following cells. 3. PROPER functionWe can use this function to convert the first letter t....

    Writer 0.1923 views
    How to view two sheets side by side

    How to view two sheets side by side

    01:09

    How to view two sheets side by side

    When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....

    Spreadsheet views
    Use the Mail Merge function to input tabular data quickly

    Use the Mail Merge function to input tabular data quickly

    01:49

    Use the Mail Merge function to input tabular data quickly

    WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....

    Writer views
    Text direction in WPS Presentation

    Text direction in WPS Presentation

    02:34

    Text direction in WPS Presentation

    When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....

    Presentation views
    Use the fill handle to quickly enter data

    Use the fill handle to quickly enter data

    02:59

    Use the fill handle to quickly enter data

    AutoFill can help us quickly enter some regular data, which is an essential skill in using WPS Spreadsheet to deal with different data. It includes Fill Numerical Value, Fills Data, Fill Text, Custom Text Filling, and Fill Formulas.Take this table as an example. If we want to fill in the numbers 1 to 10 in column A, select cell A2 and move the cursor to the lower right corner of cell A2. At this time, the cursor will turn into a small black solid cross. Press and hold the left mouse bu....

    Spreadsheet views
    How to use the spell-check function

    How to use the spell-check function

    02:31

    How to use the spell-check function

    The spell-check function of WPS helps us to quickly check spelling mistakes and provides suggestions for corrections. It saves us a lot of time to align documents. We can see that some of the content of this document has been marked with red underlines because WPS Office judged that the content of the text is wrong. At this time, we need to correct the marked content to eliminate these red underlines.Click the Review tab and click the Spell Check button. A pane will pop up on the right....

    Writer 0.1291 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 0.5531 views
    Prev 123...1516 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
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches