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

        377 results for how do i put a shortcut on my desktop

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

        377 results for how do i put a shortcut on my desktop

        Edit settings in WPS Spreadsheet

        Edit settings in WPS Spreadsheet

        03:47

        Edit settings in WPS Spreadsheet

        WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

        Spreadsheet 25.3K views
        The Graffiti function used to mark in PDF

        The Graffiti function used to mark in PDF

        01:41

        The Graffiti function used to mark in PDF

        Do you know how to draw on a PDF file? Let's try the "Graffiti" function! It can make your notes on PDF more fancy. Open the PDF in WPS Office. Get into the "Comment" tab, and click "Graffiti". In its dropdown list, we can access quick settings of the ink mark, including line colour, opacity, and line width. We can also use the shortcut keys "Alt+R" to open the settings window.Supposed that you need to mark continuous content, follow these few steps. Click "Draw curve". Then, choos....

        PDF 6.3K views
        How to add background to PDF files

        How to add background to PDF files

        01:56

        How to add background to PDF files

        When we are editing PDF documents, if the entire white layout is too simple, we can add a nice background. Let's learn the tips for beautifying PDF files with WPS Academy. Take this document as an example. Click the Insert tab, the Background drop-down menu, and then click Add Background. In the dialog box, we can add pure color background to the document, or customize the background image. Click Browse and select a suitable picture from the computer.In Surface, we can adjust the r....

        PDF 14.7K views
        Relative reference, absolute reference, and mixed reference

        Relative reference, absolute reference, and mixed reference

        03:46

        Relative reference, absolute reference, and mixed reference

        When copying formulas to other cells, we might encounter three reference modes, namely relative reference, absolute reference, and mixed reference. We need to choose the proper reference method according to the specific calculation requirements and the formula. · 1. Relative ReferenceWhen copying formulas to other cells, the formula will change according to the position of the referenced cell.Take this table as an example. Enter =B2*C2 in cell D2, and then pull down the fill handle to ....

        Spreadsheet 8.7K views
        Use the ROW function to mark the row number

        Use the ROW function to mark the row number

        02:04

        Use the ROW function to mark the row number

        When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....

        Spreadsheet 12.7K views
        More features in Screenshot

        More features in Screenshot

        02:02

        More features in Screenshot

        Both WPS Writer and Microsoft Word have the function of the screenshot. What are the differences between them? In Microsoft Word, two methods are available. One is Available Windows, which means to capture the opened windows on our desktop; the other is Screen Clipping. We need to capture the screen by manually adjusting its size in this mode, and only the area outside the Excel document is available. In WPS Writer, we can enter the Insert tab and click the Screenshot drop-down button.....

        Writer 6.9K views
        Learn pivot table from the beginning

        Learn pivot table from the beginning

        04:27

        Learn pivot table from the beginning

        A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....

        Spreadsheet 55.9K views
        Use the Today function to quickly calculate days between dates

        Use the Today function to quickly calculate days between dates

        01:57

        Use the Today function to quickly calculate days between dates

        In the application of WPS Office Spreadsheet, we usually calculate days between dates. So, how can we do a quick calculation? First, I will teach you how to use Today function to calculate days between the current date and the future date. If you are the HR of a company, you can use the Today function to calculate the remaining time of each employee's contract period when you manage the contract period of your employees. It can clearly show you the employees whose contracts are abo....

        Spreadsheet 27.6K views
        Prev 1 2 3 ... 47 48 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