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

        359 results for how much space does office 365 take on mac

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

        359 results for how much space does office 365 take on mac

        How to set the header row across pages

        How to set the header row across pages

        00:50

        How to set the header row across pages

        When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

        Writer 9.7K 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 17.1K views
        How to use the Smart Split Columns feature

        How to use the Smart Split Columns feature

        02:34

        How to use the Smart Split Columns feature

        The Smart Split Columns feature of the WPS Spreadsheet can divide the table content into columns according to the table content in four ways.· Delimiter:Take this table as an example. If we look through the table carefully, we can find that although the cells contain a lot of data, the data are all separated by space. 1. Now click Text to Columns in the Data tab, and click Smart Split Columns.2. After a dialog box pops up, we can view the result of Smart Split Columns in the preview wi....

        Spreadsheet 27.2K views
        SUBTOTAL function: Calculate the data with the hidden value

        SUBTOTAL function: Calculate the data with the hidden value

        02:33

        SUBTOTAL function: Calculate the data with the hidden value

        Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....

        Spreadsheet 23.9K views
        How to use the automatic numbering

        How to use the automatic numbering

        02:11

        How to use the automatic numbering

        We often use the automatic numbering function when editing documents, which can enrich the structure of the document and make it easier to read. How can we use this function? Take this catalog as an example. Select the content that needs to be numbered, click the Numbering drop-down button on the Home tab, and choose the style we want. To get more styles, we can click More Numbering on the Numbering drop-down button. A dialog box will pop up at this time. After selecting any of the st....

        Writer 29.9K views
        The Word Typesetting function in WPS Writer

        The Word Typesetting function in WPS Writer

        03:05

        The Word Typesetting function in WPS Writer

        Do you want to layout your articles more efficiently? WPS Office provides us with a useful and practical function: the Word Typesetting function. Navigate to the Home tab, and click the Word Typesetting drop-down button. Then we can see a lot of text typesetting functions.Tips: you can turn on the Show/Hide Paragraph Marks button for subsequent operations.l Insert blank paragraphs In this document, for example, there is no space between paragraphs, which looks dense and does not fit th....

        Writer 18.0K views
        How can we create a drop-down list

        How can we create a drop-down list

        01:33

        How can we create a drop-down list

        How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....

        Spreadsheet 38.0K 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 24.3K views
        Prev 1 2 3 ... 44 45 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