WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • f5 shortcut excel

    2378 results for f5 shortcut excel

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

    2378 results for f5 shortcut excel

    Must-have shortcut tricks in showing slides

    Must-have shortcut tricks in showing slides

    01:47

    Must-have shortcut tricks in showing slides

    When showing slides in WPS Presentation, we can greatly improve the efficiency with some shortcut tricks. lQuickly show slidesWhen there are multiple slides, and we want to start from the first slide, it's troublesome to find the first slide and click to show. At this time, we can use the shortcut key F5 to quickly realize the operation. For example, now we come to the seventh slide, and you can press F5 to jump back to the first slide. To directly start from the current slide, use....

    Presentation 1.3K views
    Must-have shortcut tricks in making slides

    Must-have shortcut tricks in making slides

    02:24

    Must-have shortcut tricks in making slides

    During study and work, WPS Presentation is often needed to make a PPT. What makes a high-quality PPT during a short time? In today's tutorials, we will learn a few quick tips commonly used in creating slideshows and thus improving efficiency. · Create a new slideSelect any slide, use the shortcut key Enter, or press Ctrl+Enter together to quickly insert a blank slide. · Delete the current slideSelect the current slide and use the shortcut key Delete or press Ctrl+Delete to remove i....

    Presentation 1.2K views
    Use the shortcut Alt+= to quickly sum

    Use the shortcut Alt+= to quickly sum

    01:02

    Use the shortcut Alt+= to quickly sum

    In tables, we often have to perform summation operations. Using the function to sum and then filling the cells with the fill handle is too troublesome. However, the sum shortcut Alt+= can help us quickly sum. Take this table as an example. We need to sum the column data of the table, just select the sum range B16:F16, then press the shortcut Alt+= to quickly complete the summation.Similarly, if we want to sum the row data, we can simply select the range G2:G15 that needs to be summed a....

    Spreadsheet 1.5K views
    How to customize text shortcut keys

    How to customize text shortcut keys

    01:33

    How to customize text shortcut keys

    We can process and edit documents more quickly by flexibly using shortcut keys.Then, how can we customize shortcut keys in WPS Office? First, click Menu and Options to enter the Customize Ribbon interface.You can see Keyboard shortcuts in the lower-left corner. Click Customize to take you to the custom settings dialog. Take Insert Picture as an example. Head to the Insert tab in the left categories, and then find Insert Picture in the corresponding commands on the right.You can see th....

    Writer 2.0K views
    How to set custom symbols and symbols shortcut key

    How to set custom symbols and symbols shortcut key

    01:32

    How to set custom symbols and symbols shortcut key

    In the process of editing documents, we occasionally need to re-enter the same symbols. Take this table as an example. When we make an account for purchased fruits, we need to enter the weight unit kg, so how can we quickly enter it? In the Insert tab, click the Symbol drop-down button, and then click More Symbol to pop up a dialog box.In the Custom Symbols tab, we can see many system-defined symbols, including the kg we need to enter. After clicking kg, click the Shortcut keys edit b....

    Writer 3.3K views
    How to set custom symbols and symbols shortcut key in WPS Spreadsheet

    How to set custom symbols and symbols shortcut key in WPS Spreadsheet

    01:51

    How to set custom symbols and symbols shortcut key in WPS Spreadsheet

    When using tables to enter data, if we often need to enter symbols, we can set shortcut keys for commonly used symbols, which can improve our work efficiency. Take this size chart as an example. We need to enter the length unit cm multiple times, so how can we get a quick input? Click the Home tab, and the Symbol drop-down button, then click More Symbol to pop up a dialog box. Click the Custom Symbols tab, and then we can see that there are many system-defined symbols, including the cm....

    Spreadsheet 2.4K views
    The SUMPRODUCT function for quick calculation of total sales

    The SUMPRODUCT function for quick calculation of total sales

    01:44

    The SUMPRODUCT function for quick calculation of total sales

    When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

    Spreadsheet 2.6K views

    Shortcut keys in PowerPoint

    Shortcut keys can improve our work efficiency greatly. Here are the most common ones.Ctrl+A: to select all the elements in the slideCtrl+M: to insert a new slideCtrl+B: to make the selected text boldCtrl+I: to italicize the selected textCtrl+U: to underline the selected textCtrl+C: to copy the selected objectsCtrl+V: to paste the copied objectsCtrl+X: to cut the selected objectsCtrl+E: to center textCtrl+L: to align text to the leftCtrl+F: to find text in the docmentCtrl+H: to replace ....

    ppt Presentation 2.4K views
    Prev 1 2 3 ... 297 298 Next
    WPS Academy
    Products
    Partners