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

        2270 results for design table in excel

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

        2270 results for design table in excel

        Insert a symbol in the table

        Insert a symbol in the table

        02:36

        Insert a symbol in the table

        When using WPS Spreadsheet, we often need to insert some special characters in the text content. Sometimes when we need to insert special symbols such as m2, ℃, etc., it is not quite convenient to use the keyboard to input them. At this time, we can use the Symbol feature of WPS Spreadsheet to meet our needs. Take this table as an example. This is the Weekly Attendance Sheet of employees. We now need to add an area unit m2 after 1000 in the third row. Click the Insert tab, and then cli....

        Spreadsheet 26.2K views
        Add blank rows in an individual table

        Add blank rows in an individual table

        01:02

        Add blank rows in an individual table

        Sometimes there are several tables in one worksheet, and we want to add blank rows in one of the tables. How can we solve it? Take this worksheet as an example. Suppose we need to add a blank row in the left table. At this time, if we use the frequently used method, which is to select the desired range and right-click to insert a blank row, we can find that a blank row is also inserted in another table. Thus, we need to use another method to insert the blank row.Firstly, select the loc....

        Spreadsheet 6.8K views
        Merge and split table cells in WPS Writer

        Merge and split table cells in WPS Writer

        01:09

        Merge and split table cells in WPS Writer

        Today we are going to learn how to merge and split table cells in a document.Take this table as an example.· Merge cellsHere, we can merge cells. Select the cell in the first column and click the Merge Cells button in the Table Tools tab to merge the cells. · Split Cells1. If we want to divide a cell into several cells, we can select the cell that needs to be split. 2. Click the Split Cells button in the Table Tools tab.3. In the pop-up dialog box, we can set the number of columns and ....

        Writer 16.9K views
        Design the article layout in the Home-Settings

        Design the article layout in the Home-Settings

        03:26

        Design the article layout in the Home-Settings

        When designing the layout of the document, we often need to set the text font, paragraph settings, and heading style.In WPS Writer, these frequently used typesetting tools are collected in the Settings button under the Home tab. l Font settingTake this document as an example. We need to set the text format.Press the shortcut Ctrl+A to select the whole document, and click Font.We can change Font, Font style, Size, Color,and other parameters of the text.In the Effect area under the Font....

        Writer 12.3K views
        How to display the obscured table text in WPS Writer

        How to display the obscured table text in WPS Writer

        01:56

        How to display the obscured table text in WPS Writer

        When a table is inserted in a word document, the text in the table may not display completely. Do you know how to fix it? l Case 1: Table exceeds page sizeWhen we copy the table in other platforms to insert it into the document, and the table exceeds the page width, the text on the right of the table will be incomplete.In most cases, we can use the mouse to slowly drag the box line to adjust to the appropriate position, which is too troublesome.Here is a practical trick helping you ad....

        Writer 7.4K 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 10.1K 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 24.1K 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.3K views
        Prev 1 2 3 ... 283 284 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