WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to sort in numbers

    802 results for how to sort in numbers

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

    802 results for how to sort in numbers

    How to sort text in WPS Writer

    How to sort text in WPS Writer

    02:37

    How to sort text in WPS Writer

    When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....

    Writer views
    How to sort with a custom list

    How to sort with a custom list

    01:36

    How to sort with a custom list

    How can we sort the table with a custom list when designing a report? Today, we will learn how to create a custom list for sorting.For example, we want to sort this table by position. Click Custom Sort in the Data tab to pop up a dialog.By default, the system sorts letters and integers in ascending or descending order on their values.Click the drop-down list at Order and select Custom Lists.Custom lists on the left tell the built-in sorting rules. We can customize the sorting rules at ....

    Spreadsheet views
    How to set the line numbers in WPS Writer

    How to set the line numbers in WPS Writer

    01:56

    How to set the line numbers in WPS Writer

    The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

    Writer views
    How to convert numbers into percentages

    How to convert numbers into percentages

    01:08

    How to convert numbers into percentages

    We can directly know the relationships between the part and the whole in our daily work with statistical values shown as percentages. Take this table as an example. We want to calculate the percentage of January sales in annual sales so that we can apply the percentage format here.First, select the cell D2 and enter the formula “=B2/C2”. Then use the fill handle to pull down, and we can get the sales of each employee in January of this year. Then we select the cells D2-D15. Click the N....

    Spreadsheet views
    How can we insert page numbers in WPS Writer

    How can we insert page numbers in WPS Writer

    02:49

    How can we insert page numbers in WPS Writer

    In the process of document typesetting, adding page numbers can help us quickly retrieve and locate. So, how can we insert the page number into a document? Take this document as an example. Click the Insert tab first, then click the Page Number drop-down button. In the Built-in Style, we can choose the style according to demand. If there is no suitable page style, we can click the Insert Page Number button to set up. In the pop-up Insert Page Number dialog box interface, we can set the....

    Writer 0.5587 views
    How to use the MID function in WPS Spreadsheet

    How to use the MID function in WPS Spreadsheet

    01:54

    How to use the MID function in WPS Spreadsheet

    When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....

    Spreadsheet views
    How to insert a table in WPS Presentation

    How to insert a table in WPS Presentation

    01:47

    How to insert a table in WPS Presentation

    When creating a presentation in WPS Office, sometimes we need to insert a table for data demonstration. How can we realize it? Take this PowerPoint as an example. Get into the Insert tab and click the Table dropdown menu. Then drag the cursor to decide the table size. This method allows us to create a table with 10 columns and 10 rows at maximum. If we want to insert a bigger table, choose Insert Table. In the Insert Table dialog, we can decide the numbers of columns and rows. Enter t....

    Presentation 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 views
    Prev 123...100101 Next
    WPS Academy
    Products
    Partners