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

        692 results for kingsoft office 2019

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

        692 results for kingsoft office 2019

        Hyperlink in WPS Office Spreadsheet

        Hyperlink in WPS Office Spreadsheet

        02:22

        Hyperlink in WPS Office Spreadsheet

        When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....

        Spreadsheet 89.0K views
        Set the page printing area in WPS Office Spreadsheet

        Set the page printing area in WPS Office Spreadsheet

        00:47

        Set the page printing area in WPS Office Spreadsheet

        What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

        Spreadsheet 27.3K views
        Get to know the WPS Spreadsheet

        Get to know the WPS Spreadsheet

        02:04

        Get to know the WPS Spreadsheet

        WPS is an Office Software developed by Kingsoft. This video is going to introduce WPS to you. Before you start watching, remember to download the latest WPS Office Suite from our official website. After we download, open WPS. Then we will come to the workbench interface. Click the + icon in the upper left corner. We can choose to create a new document, table, slides, or PDF in the menu bar. Here, we want to create a spreadsheet, so we select Spreadsheet. Then we can see a Blank button ....

        Spreadsheet 8.3K views
        Basic settings on footer and header

        Basic settings on footer and header

        01:44

        Basic settings on footer and header

        When we are editing documents, we sometimes need to add additional information such as company name, logo, date, etc. in the header and footer. The additional information ensures the integrity of the document. This video of Basic settings on footer and header could be also used in Microsoft Office Word and Openoffice. Steps:Take this document as an example. 1. Click the Insert tab, and then the Header and Footer button in turn. 2. Click the header text box, and enter “Kingsoft Office”....

        Writer 45.5K views

        How to import text file into excel 2019 with columns

        Excel is a powerful software program that is used by users of every field. Excel offers many unique and useful features which have flourished the digital world. Excel has recently become a popular and most used platform which has benefited different users related to different fields. Excel was specifically designed for business and accountings due to its distinctive functions of sorting and organizing data and financial analysis. But in the current era it has emerged to play a vital ro....

        xls Spreadsheet 5.9K views

        How to convert text to numbers in Excel 2016 and 2019 online

        How to convert text to numbers in excel online, 2016 and 2019: There are several ways to convert text to numbers in Excel. Making a rapid text to number conversion using an Excel function. Make use of a special cell formatting method. The text-to-column method Use of the VALUE function is made. Using the Excel option to quickly convert text to numbers: It's probably the simplest approach for Excel. In Excel, the apostrophe (') is commonly used before entering integers. We mus....

        xls Spreadsheet 4.1K views

        How to convert numbers to text in Excel 2016 and 2019

        How to convert numbers to text in excel online, 2016 and 2019: I'll go over four alternative methods in this section for converting numbers to text in Excel. These techniques are not all the same, and depending on your circumstances, some may be better suited than others. So let's get started with how to convert numbers to text in excel! Adding an Apostrophe: Here is a quick tip if you're manually entering data in Excel and don't want your numbers to automatically c....

        xls Spreadsheet 2.5K views
        Customize the formats to show data changes

        Customize the formats to show data changes

        01:28

        Customize the formats to show data changes

        Comparing and analyzing similar data is something we have to do. Today, we will look at how to customize the formats to show data changes.Take this table as an example. Subtract the data of 2018 from that of 2019 to get the difference. Positive numbers show progress, while negative numbers indicate underperformance and entail attention.To better illustrate, we want to display the increase in green and highlight the decrease in red with a * symbol. Right-click the data area and choose F....

        Spreadsheet 8.4K views
        Prev 1 2 3 ... 86 87 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