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

        1802 results for how to add gridlines to excel spreadsheet

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

        1802 results for how to add gridlines to excel spreadsheet

        How to add gridlines and guides in WPS Presentation

        How to add gridlines and guides in WPS Presentation

        01:31

        How to add gridlines and guides in WPS Presentation

        When we make a slideshow, in order to achieve a good typographic effect, we generally add guides and gridlines to the page. Take this slide as an example. It is difficult for us to center the title without smart assisted alignment. At this point, we only need to click the View tab above, then click the Grid and Guides button, finally check Display smart guides on screen. With the help of smart guides, centering the title becomes simple. Learn to use guides, and we can achieve more type....

        Presentation 16.1K 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 13.0K views
        How to add a watermark

        How to add a watermark

        02:14

        How to add a watermark

        WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.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. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

        Writer 15.6K views
        How to insert an attachment in WPS Spreadsheet

        How to insert an attachment in WPS Spreadsheet

        01:28

        How to insert an attachment in WPS Spreadsheet

        When we use WPS Spreadsheet, we need to insert an attachment in the table to add a supplementary explanation. Take this table as an example. We want to insert a document attachment in the corresponding table cells to add more information. Select cell F2, click the Insert tab and the File Object button to select the document we want to insert. When we are finished, a picture of the inserted document will appear. We can adjust the picture to the appropriate size and place it in the cell.....

        Spreadsheet 8.6K views
        How to Add Caption

        How to Add Caption

        01:41

        How to Add Caption

        We can use the caption feature to number and annotate images, charts and other contents referenced in a document. So how do we use this feature? We take the image in this document as an example. Select the image, click References, and then click Caption to get a pop-up dialog.Click the Label pull-down to select the label you want. If none is available, you can click New Label to customize a label such as a Picture.Then select the Position of the caption. Click the Numbering button, you....

        Writer 14.0K views
        How to create a Form in spreadsheet

        How to create a Form in spreadsheet

        01:26

        How to create a Form in spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

        Spreadsheet 13.1K views
        How to consolidate data in WPS Spreadsheet

        How to consolidate data in WPS Spreadsheet

        01:28

        How to consolidate data in WPS Spreadsheet

        In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

        Spreadsheet 27.0K views
        How to add annotations to PDF files

        How to add annotations to PDF files

        02:08

        How to add annotations to PDF files

        When we read the information of certain PDF documents, sometimes we need to mark some important paragraphs or add corresponding comments to some content. Today I would like to introduce how to add annotations to PDF documents quickly. Take this PDF document as an example. Click the Comment tab, and click the Note Mode button. At this time, a blank page appears on the right side of the document body. We select the text that needs to be annotated, click the Highlight drop-down menu, and ....

        PDF 10.9K views
        Prev 1 2 3 ... 225 226 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