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

        2480 results for how to apply borders in excel

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

        2480 results for how to apply borders in excel

        How to set page borders in WPS Writer

        How to set page borders in WPS Writer

        01:44

        How to set page borders in WPS Writer

        When adjusting the page layout of a word document, we can add page borders and change their styles. In this example, if we want to insert page borders of the palm tree style, how can we realize it? First, click the Page Layout tab, and choose Page Borders to pop up the Borders and Shading window. Here we can access the settings of the page borders, including style, color, and width. We can see the page border of palm trees in the category of Art. In the Preview interface, we can choose....

        Writer 45.7K views
        How to customize draw borders for tables

        How to customize draw borders for tables

        01:19

        How to customize draw borders for tables

        When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

        Spreadsheet 57.3K 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 27.4K views
        How to change case, enclose characters, and apply character border

        How to change case, enclose characters, and apply character border

        01:06

        How to change case, enclose characters, and apply character border

        When editing a document, we can mark specific contents quickly with the following features.· Change CaseTake this document as an example. If we want to change the case of the selected contents, click Change Case in the Home tab.In the pop-up dialog, we can select Lowercase, Uppercase, and Capitalize each word, etc., according to our needs. · Enclose CharactersIf we want to enclose a character, such as a number in the document, select it and click Enclose Characters in the Home tab.In t....

        Writer 25.4K views
        How to compress pictures in WPS Writer

        How to compress pictures in WPS Writer

        01:06

        How to compress pictures in WPS Writer

        If we have a large number of pictures in our document, this will make the file too large for us to transfer. At this point, we can adequately compress the picture in order to reduce the file size and save the file space. First, click the picture to get into the Picture Tools tab, and click the Compress Pictures button to pop up the dialog. In the Apply to interface, we can select the range of compressing pictures.In the Change resolution interface, we can select two fixed resolutions. ....

        Writer 10.6K views
        How to convert Excel to PDF

        How to convert Excel to PDF

        02:50

        How to convert Excel to PDF

        PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

        Spreadsheet 33.5K 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 10.5K views
        How to set slide transitions in WPS Presentation

        How to set slide transitions in WPS Presentation

        01:59

        How to set slide transitions in WPS Presentation

        Appropriate transitions make slides more professional and attractive. So how can we set transitions when creating a Presentation document? Click the slide that we want to add transition animations, and click Transitions.WPS Office provides us with multiple slide transitions, such as Morph, Wipe, Push, Cube, Airplane and so on.Having selected the desired transition, click Effect Options to set the orientation and transition mode of the animation.We can apply it with one click. If we th....

        Presentation 13.4K views
        Prev 1 2 3 ... 309 310 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