WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        2922 results for All

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

        2922 results for All

        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 23.4K views
        How can we crop pictures in WPS Writer

        How can we crop pictures in WPS Writer

        01:16

        How can we crop pictures in WPS Writer

        We often insert pictures when editing documents, If we want to crop the picture, what should we do? After clicking the picture in the document, we can click the Crop drop-down button under the Picture Tools tab. We can choose Crop by Shape or Crop by Scale in the selection list.If we want to crop the picture into an oval, click Oval in the Basic Shapes selection list, and an oval will appear in the picture. The shaded part is the part that is cropped. There are four small black lines i....

        Writer 23.3K views
        Header and footer: insert alignment tabs for alignment

        Header and footer: insert alignment tabs for alignment

        01:20

        Header and footer: insert alignment tabs for alignment

        After we insert multiple contents in the header and footer area, we may choose to use the space bar to adjust the position of a certain text. Today we are going to show you how to use the Insert Alignment Tab feature to align text quickly. Place the mouse cursor in front of the content to be adjusted, and click the Insert Alignment Tab button in the Header/Footer tab. In the popup dialog box, we can set Alignment and Leader.In the following video, we will show you the effects of center....

        Writer 23.2K views
        How to adjust line spacing of the text

        How to adjust line spacing of the text

        01:18

        How to adjust line spacing of the text

        After we finish editing the text content, we need to adjust the font size and line spacing of the text in order to make it easy to read. So how can we adjust line spacing of the text? Take this document as an example, select all the text content, then click the Line Spacing button of the Home tab. Users can select the amount of line spacing here according to their needs. If there are is no proper options, users can also set line spacing by themselves. 1.Click the Line Spacing button o....

        Writer 23.1K views
        How to change case, enclose characters, and apply character border

        How to change case, enclose characters, and apply character border

        01:06

        How to change case, enclose characters, and apply character border

        When editing a document, we can mark specific contents quickly with the following features.· Change CaseTake this document as an example. If we want to change the case of the selected contents, click Change Case in the Home tab.In the pop-up dialog, we can select Lowercase, Uppercase, and Capitalize each word, etc., according to our needs. · Enclose CharactersIf we want to enclose a character, such as a number in the document, select it and click Enclose Characters in the Home tab.In t....

        Writer 23.1K views
        How to clear content format and comments for cells

        How to clear content format and comments for cells

        01:43

        How to clear content format and comments for cells

        When we use the WPS Spreadsheet to work, we sometimes need to clear the content of the table quickly. How can we realize it? This video could help to solve this problem. Take this transcript as an example. 1. To clear all contents within the table, select the area that needs to be cleared.2. Click the Clear dropdown button in the Home tab, and choose the All option to clear the table as needed. (Notes: We can also use the Clear function in this step. To realize it, select the area, and....

        Spreadsheet 23.0K views
        How can we resize the images in Documents

        How can we resize the images in Documents

        01:21

        How can we resize the images in Documents

        When using WPS Writer, we often insert pictures for instructions. Sometimes we need to resize the picture precisely. How can we adjust the size of picture in a document? In this document, insert a picture and adjust its layout. For example, we can change the layout to Behind Text in the Wrap Text catalog. Then, set the font color as white. Then right-click the image and choose More settings. In the pop-up interface Layout, click the Size tab. If we need to scale the picture proportion....

        Writer 23.0K views
        Ctrl+E smart filling

        Ctrl+E smart filling

        02:50

        Ctrl+E smart filling

        After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

        Spreadsheet 22.9K views
        Prev 1 ... 15 16 ... 365 366 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
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube