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

    3151 results for how to transpose a table in excel

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

    3151 results for how to transpose a table in excel

    How to print a table

    How to print a table

    12:23

    How to print a table

    This lesson summarizes the printing problems commonly encountered in the workplace1. How to make the printer obedient, forms are printed on a sheet of paper2. How to select the designated printing area3. When the form file is very long, how to set each page has a title line4. how to set the header and footer, so that your document more professional

    Spreadsheet 2.4K views
    How to insert a table of contents in word

    How to insert a table of contents in word

    02:00

    How to insert a table of contents in word

    A table of contents, also called TOC, is a significant part of an article. It can help readers to get the outline quickly and locate the target part. In WPS, we can insert a table of contents in a convenient way. Click the blank page inserted at the beginning of the article. Get into the Reference tab, and click Table of Contents. In the dropdown menu, we can choose from three styles of the table of contents, which presents in different layouts. Since we have "Heading 1", "Heading 2", ....

    Writer 8.5K 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 2.8K 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 18.6K views
    How to add watermarks to a table

    How to add watermarks to a table

    02:19

    How to add watermarks to a table

    Watermarking a document can prevent it from being misused by others; the good news is that watermarks can be added to an excel table.We'll look at two different ways to add watermarks to your table today.The first approach is merely adding a single watermark, which can be utilized for a single-page table.Click Insert, and then click WordArt. Select a style to be inserted, and input the watermark content.The font style can be changed further by clicking Setting in Text Tools. You ca....

    Spreadsheet 3.3K views
    How to input data into a table efficiently

    How to input data into a table efficiently

    12:21

    How to input data into a table efficiently

    1. The basic rules of inputting data.2. Commonly-used fill functions (Fill handle, Series, and Flash Fill).3. Create simple drop-down lists for higher efficiency.4. Use the OCR function for quick input.

    Spreadsheet 2.7K views
    How to create a table with one click

    How to create a table with one click

    01:35

    How to create a table with one click

    Did you know that, when you are using WPS Spreadsheet, you can directly create a table in the original datasheet? The generated table comes with functions such as sorting, filtering, and setting styles, which can save us a lot of time for subsequent operations. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Here are the steps to create a table. Take the sales table in this article as an example. 1. Click the Table button in the Insert tab. (Notes: You can also use th....

    Spreadsheet 5.7K views
    How to delete blank rows of table in batches

    How to delete blank rows of table in batches

    00:51

    How to delete blank rows of table in batches

    When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once? We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, ....

    Spreadsheet 5.4K views
    Prev 1 2 3 ... 393 394 Next
    WPS Academy
    Products
    Partners