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

    2624 results for f5 shortcut excel

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

    2624 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 2.0K 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 2.3K 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 3.2K 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.8K 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 4.7K 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 3.3K 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 3.5K views

    How to insert row shortcut in excel

    Main keyword: excel insert row shortcut. Excel insert row shortcut to get your jobs done much faster Excel has become one of the most used programs worldwide since it allows you to organize tasks. People who use Excel are surely looking for a guide to provide more information on certain techniques. It is fair that you learn everything about Excel, in this way your work will be in perfect condition. Today you have the opportunity to learn and excel insert row shortcut and thus add rows ....

    xls Spreadsheet 2.5K views
    Prev 1 2 3 ... 327 328 Next
    WPS Academy
    Products
    Partners