WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to alphabetize a column in excel

    2760 results for how to alphabetize a column in excel

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

    2760 results for how to alphabetize a column in excel

    How to draw a column chart in WPS Spreadsheet

    How to draw a column chart in WPS Spreadsheet

    01:46

    How to draw a column chart in WPS Spreadsheet

    A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....

    Spreadsheet 3.6K views
    How to set a worksheet in WPS Spreadsheet

    How to set a worksheet in WPS Spreadsheet

    03:53

    How to set a worksheet in WPS Spreadsheet

    The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

    Spreadsheet 3.2K views
    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 2.4K views
    How to insert shapes in a worksheet

    How to insert shapes in a worksheet

    01:20

    How to insert shapes in a worksheet

    We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

    Spreadsheet 1.9K views
    How to insert a signature in a PDF file

    How to insert a signature in a PDF file

    02:16

    How to insert a signature in a PDF file

    We use powerful PDF in our daily life nearly everyday. WPS pdf converter is easy and free for people to use.Nowadays, electronic information technology is developing rapidly. Many companies have adopted paperless contracts, and we often need to sign a contract or agreement on an electronic device. Now we have received a PDF contract from another company, and we need to sign it. So how can we insert a signature in the PDF file?1. Click the Insert tab, and then click the Sign drop-down m....

    PDF 5.7K 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 3.5K views
    How to crop the picture in a table

    How to crop the picture in a table

    01:30

    How to crop the picture in a table

    Sometimes we need to crop the picture into the shape we want after inserting it. So how can we do that? Take this table as an example. We have inserted a picture of the clothes on the table, but the picture is a little large. We need to crop it into the right shape and size. Click on the picture to jump to the Picture Tools tab. Click the Crop drop-down button, and we can see two options. Here we select Crop by Scale to adjust its scale. We select the 1:1 scale to crop the picture. No....

    Spreadsheet 13.8K views
    How to insert a watermark in a PDF file

    How to insert a watermark in a PDF file

    01:47

    How to insert a watermark in a PDF file

    We use powerful PDF in our daily life nearly everyday. We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article.You can use the “insert watermark” feature of WPS Premium. Take this PDF as an example. Click the Insert tab, then click Watermark. WPS Office has provided us with some preset styles. We can click to use them directly. We can also customize the wa....

    PDF 1.9K views
    Prev 1 2 3 ... 344 345 Next
    WPS Academy
    Products
    Partners