Your browser version is outdated.
To browse WPS Academy normally, we recommend you to upgrade to the latest version of Internet Explorer or try other browsers.
chrome
Chrome
firefox
Firefox
WPS Academy

WPS Academy Free office suite tutorials

  • 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
    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
    • Home
    • Popular
    • strikethrough in excel

    900 results for strikethrough in excel

    • All Tutorials
    • Video Tutorials
    • Quick Tutorials
    • All
    • Spreadsheet
    • Presentation
    • Writer
    • PDF
    How can we add underline and strikethrough

    How can we add underline and strikethrough

    01:02

    How can we add underline and strikethrough

    When using WPS Writer to review the manuscript, we sometimes add underline or strikethrough to highlight or delete the content. In this document, we can underline or emphasize the sentence. Select the corresponding part, click the Home tab, and then the Underline drop-down button. Then, we can change the types and colors for the underline. For more underline styles, click More Underlines to bring up the Font dialog. In the category of All text - Underline style, we can select more oth....

    Writer 2,431 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 287 views
    How can we change the font in a cell

    How can we change the font in a cell

    01:09

    How can we change the font in a cell

    When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell? In this spreadsheet, select a range of cells. In the Home tab , we can change text settings including Size and Text Color , and add effects for the texts such as Bold, Italic, Fonts, Underline, etc. 1. Select the cells filled with WPS Academy.2. Right-click the cells, and choose Format cells in the pop-up menu. Or we can just select the cells and press the shortcut Ctrl+1.3. Click the Font tab ....

    Spreadsheet 2,223 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 5,531 views
    More features in picture inserting

    More features in picture inserting

    01:53

    More features in picture inserting

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. WPS Spreadsheet and Microsoft Excel both have the function of inserting pictures. Compared with Microsoft Excel, WPS spreadsheet has an added advantage-Embed to cell. In Microsoft Excel, we usually need to manually adjust the size of the pictures after inserting them. If the position of the table changes, the inserted pictures will not fit in the new ce....

    Spreadsheet 61 views
    TEXT formula in WPS Spreadsheet

    TEXT formula in WPS Spreadsheet

    03:09

    TEXT formula in WPS Spreadsheet

    The TEXT formula in Excel is commonly used for the conversion of number-to-text in a certain format, and it could be also used in Microsoft Office Excel and Openoffice. Normally, the TEXT formula is used to customize format cells in terms of actual needs. To realize it, we need to adjust the second parameter of the formula, which stands for format texts to be set. In this example, the number 2.012584, which equips with six decimal places, entered cell A2. How can we convert it into a v....

    Spreadsheet 1,560 views
    More features in Splitting Columns

    More features in Splitting Columns

    03:06

    More features in Splitting Columns

    When several pieces of information are filled in one cell, we often need to split it into multiple columns, and both WPS Spreadsheets and Microsoft Excel support splitting columns. Take this table as an example. In Microsoft Excel, we select the cell range of A2:A11, click the Data tab, click Text to Columns, and we can choose Delimited or Text Width to split columns manually. In addition to this original method, WPS Spreadsheets has a new feature, namely, Smart Split Columns. It has t....

    Spreadsheet 89 views
    More features in Screenshot

    More features in Screenshot

    01:56

    More features in Screenshot

    Both WPS Spreadsheets and Microsoft Excel have the function of a screenshot. What are the differences between them? In Microsoft, we can click the Screenshot drop-down button and select one of the Available Windows to take a screenshot. Click Screen Clipping to capture the screen by adjusting its size manually, and only the area outside the Excel document is available. In WPS Spreadsheets, we have two ways of screenshot for your selection.Option 11. Click the Insert tab, click the Scre....

    Spreadsheet 34 views
    Prev 123456...112113 Next
    WPS Academy
    Products
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches
    Partners
    WPS Office for Windows
    WPS Office for Mac
    WPS Office for Android
    WPS Office for iOS
    WPS Office for Linux
    Affiliate Program
    Links
    OEM Partners
    Strategic partners
    Enterprise Sales
    Popular Searches