WPS Academy
Top Searches
    Login/Sign up
    Login/Sign up
    • Home
    • Popular
    • keyboard shortcuts

    43 results for keyboard shortcuts

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

    43 results for keyboard shortcuts

    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 views
    Use Validation to restrict date entries

    Use Validation to restrict date entries

    01:10

    Use Validation to restrict date entries

    When editing a spreadsheet, we may want to restrict the contents to ensure effectiveness, such as requiring the dates cannot exceed today. Today we will tell you how to restrict the input dates using Validation.First, select the cell range that contains the dates. Click Validation in the Data tab or use the shortcuts Alt+D+L.The Data Validation dialog will pop up, where you can select Date at Allow. Then, click the Data drop-down button to restrict the date range. Here, we select less ....

    Spreadsheet views
    Ctrl+E smart filling

    Ctrl+E smart filling

    02:50

    Ctrl+E smart filling

    After getting in touch with WPS, we know that Ctrl+C copy and Ctrl+V paste are two shortcuts, which can easily improve office efficiency. Few people know about Ctrl+E smart filling, which can intelligently identify the pattern by comparing the characters’ relationship and quickly fill cells. Next, I will introduce the usage of the smart filling shortcut key Ctrl+E. · 1. Extract charactersIn this table, we want to extract all the names in the sentences. First, enter the name that appear....

    Spreadsheet views
    How to use the selection feature

    How to use the selection feature

    02:58

    How to use the selection feature

    The selection feature in WPS Writer is diversified and can meet a variety of needs.· Select AllTake this document as an example. Click the Select drop-down button in the Home tab, and click Select All to select the whole text, or use the shortcut key Ctrl+A. Now click any area with the mouse to cancel the selection. Here are some other shortcuts for text selection:1. Double-click the mouse quickly. Then WPS Writer will automatically select the byte, that is, a word. 2. First select a c....

    Writer views
    Make a countdown calendar in WPS Spreadsheet

    Make a countdown calendar in WPS Spreadsheet

    01:37

    Make a countdown calendar in WPS Spreadsheet

    It would be helpful to insert a countdown calendar into a project schedule so that we can view the deadline every time we open it. So today we are going to learn how to make a countdown calendar. Take this table as an example. 1. On the right of "Current date," input the formula "=TODAY()" and press the Enter key on the keyboard to return the current day.The Today function can synchronize the date set on the current computer so that the current date will update automatically every time....

    Spreadsheet views
    How can we insert symbols in WPS Writer

    How can we insert symbols in WPS Writer

    01:50

    How can we insert symbols in WPS Writer

    When we edit a document, we will inevitably need to enter some symbols that are not directly entered by the keyboard input method. So, how do we insert the special symbols that we need? Take this document as an example. We want to tick the tourist attractions we have visited to facilitate statistics. Click the position where we want to insert the symbol and click the Insert tab and the Symbol drop-down button. We can see Recently Used Symbols and Custom Symbols here. These are the ....

    Writer 0.5494 views
    Wrap text in a cell

    Wrap text in a cell

    00:53

    Wrap text in a cell

    When we edit a document, we only need to press the Enter key on the keyboard to wrap text. When we edit spreadsheets, we press the Enter key to edit the cells in the next line, then how can wen wrap text in a cell? This video could help to solve the problem of Wrap text in a cell and could be also used in Microsoft Office Excel and Openoffice. The first method is to use the shortcut key Alt + Enter ; we can wrap text in a cell as we need. The second method is to click the Home tab and ....

    Spreadsheet 0.4096 views
    How to insert the symbol in WPS Presentation

    How to insert the symbol in WPS Presentation

    01:54

    How to insert the symbol in WPS Presentation

    When editing WPS presentation files, we will inevitably need to enter some symbols that cannot be directly entered through the keyboard. So, how can we insert the special symbols as needed? Take the slides as an example. To facilitate statistics, we want to tick the box after the tourist attractions we have already visited. Click where we want to insert the symbol, click the Insert tab and the Symbol drop-down button. Here, we can see Recently Used Symbols and Custom Symbols. These are....

    Presentation views
    Prev 123...56 Next
    WPS Academy
    Products
    Partners