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

        2359 results for how to make a group dropbox

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

        2359 results for how to make a group dropbox

        How to group data in a spreadsheet

        How to group data in a spreadsheet

        02:01

        How to group data in a spreadsheet

        When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....

        Spreadsheet 13.1K views
        How to group objects in WPS Spreadsheet

        How to group objects in WPS Spreadsheet

        01:20

        How to group objects in WPS Spreadsheet

        In the workplace, we sometimes need to adjust the objects in WPS Spreadsheet uniformly. In today's tutorial, we will learn how to group multiple objects in excel.For example, moving the figure in the upper left corner as a whole will separate the header and the content box.To solve this, we can hold down the "Shift" key to select both the header and the content box. Then the ribbon will switch to "Drawing Tools," where you can click "Group." This button can also be found in the sho....

        Spreadsheet 9.3K views
        How to make a resume to impress picky HR

        How to make a resume to impress picky HR

        04:35

        How to make a resume to impress picky HR

        An amazing resume is a must-have for the employee who wants to stand out among job applications.Today we will learn how to create a resume in excel.First, set the page size.Head to the "Page Layout" tab and set the page as A4 at "Size." Then select the default "Narrow" at "Margins." Step two, decide where to arrange your texts.Before setting the area, click "Page Break Preview" in the lower right corner to change the view mode. So we can better understand the sector locations for the s....

        Spreadsheet 16.0K views
        Using Tab stop to make a slide catalog

        Using Tab stop to make a slide catalog

        01:07

        Using Tab stop to make a slide catalog

        When making a slide catalog, we need to typeset the text to make the page look neater. Beginners will use the space bar to align the text one by one, but this is more troublesome. Is there any other way to quickly align the pages? First we need to click the View tab above, and then check Ruler. The ruler above the slide helps us determine the length of the Tab stop. Click the Menu drop-down button, and click Format, finally click Paragraph. In the Paragraph dialog box, click the Tabs b....

        Presentation 15.7K views
        How to make conference table cards in batches

        How to make conference table cards in batches

        02:58

        How to make conference table cards in batches

        Making conference table cards is a necessary skill for civilian staff. Today we will learn about how to make double-sides conference tables. Step 1. Create a single table.First of all, click the Page layout tab, and set the page layout to Landscape.To make the table more exquisite, we have inserted a two-column, one-row table and a background image into the document in advance.Now, we can choose the desired WordArt effect and add it to the appropriate position in the cells on both side....

        Writer 5.4K views
        How to make a simple lottery through the RANDBETWEEN Function?

        How to make a simple lottery through the RANDBETWEEN Function?

        02:02

        How to make a simple lottery through the RANDBETWEEN Function?

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn the basic usage of the RANDBETWEEN function, which can be used to return a random integer between two specified numbers. This function is relatively simple. For example, if I want to randomly generate an integer between 1 and 100, I only need to enter = RANDBETWEEN(1,100) in the cell and press the Enter key. What should I do if I wa....

        Spreadsheet 11.5K views
        How to make elegant charts in WPS Writer

        How to make elegant charts in WPS Writer

        02:11

        How to make elegant charts in WPS Writer

        Plain charts in a word file may fail to attract viewers. Subscribe to WPS Template membership, and you will be free to download beautiful charts from the vast library of charts to enhance the design and appeal of your charts. Click the Insert tab, click the Chart library button, and you are provided with diverse chart types like Column, Line, Pie, etc. You can choose a preferred type, and on the detail page, choose the desired chart to insert into the document quickly. If we need to ....

        Writer 7.6K views
        How to edit a picture in a PDF file

        How to edit a picture in a PDF file

        01:54

        How to edit a picture in a PDF file

        When editing a PDF file, do you know what to do if you want to make a secondary modification to the picture on the page?Go to WPS Premium, and you will be able to use the editing feature. Take this document as an example. Click the picture you want to modify, then a small icon will appear in the upper right corner of the picture. Click it to enter the picture editing mode.At this point we use the mouse to drag the picture to move its position. As we move the picture, auxiliary lines wi....

        PDF 22.1K views
        Prev 1 2 3 ... 294 295 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