WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • how to format pivot table

    305 results for how to format pivot table

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

    305 results for how to format pivot table

    How to set the calculated field of the pivot table

    How to set the calculated field of the pivot table

    01:49

    How to set the calculated field of the pivot table

    We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....

    Spreadsheet 0.1773 views
    How to change the table format

    How to change the table format

    00:51

    How to change the table format

    When using WPS Spreadsheets, we can use the Fill Color tool to change the cell color. Are there any other methods to change the table style quickly? WPS Spreadsheets can realize it with its Format as Table function. 1. Select a cell range to be set. Get into the Home tab and click Format as Table to show its dropdown menu, where we can choose one from the default formats. 2. Left-click on any of the formats. Then, we can see the Format as Table dropdown menu. 3. Check the option titled....

    Spreadsheet 0.1156 views
    How to apply accounting number format in WPS Spreadsheet

    How to apply accounting number format in WPS Spreadsheet

    00:56

    How to apply accounting number format in WPS Spreadsheet

    WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

    Spreadsheet views
    How to quickly update the table of contents

    How to quickly update the table of contents

    01:10

    How to quickly update the table of contents

    How can we quickly update the table of contents when we need to modify the title content, location, and page number after setting up the table of contents? Take this document as an example. We found that the current page number is incorrect, so we modified the page number. At this time, the page numbers in the table of contents are not updated. And now we click the table of contents, and click the Update TOC button of the References tab. In the pop-up dialog, we choose Update page numb....

    Writer 0.1004 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 views
    How to set the Layout Format

    How to set the Layout Format

    02:11

    How to set the Layout Format

    The Page Layout function of WPS has aimed at the articles containing section breaks, the position setting of the header and footer, and the change of the measurement unit of the document. Take this document as an example. We will explain its features to all of you.· SectionThis is a document containing a section break. We can first click the Section Navigation Pane button in the Section tab, and then we can see the article is divided into four sections in the navigation pane on the lef....

    Writer 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 0.12 views
    How to use the draw table tool

    How to use the draw table tool

    01:29

    How to use the draw table tool

    WPS Writer's draw table feature allows us to use the mouse to draw custom tables directly in the document. So, how can we do it? Click this table in the document. Click the Table Tools and the Draw Table button, and then the mouse cursor will become a brush, then we can draw tables in the document as needed. If we now want to draw a 3X4 table, hold down the left button on the mouse. At this point, the table dotted lines will appear on the page, and a floating window will appear in ....

    Writer views
    Prev 123...3839 Next
    WPS Academy
    Products
    Partners