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

    211 results for windows keyboard shortcuts

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

    211 results for windows 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

    How to merge standalone windows

    Click the Merge standalone windows icon at the upper-right corner of the stand-alone window. WPS Office Suite is a high-performance and reliable office suite designed to protect data and information for both PC and mobile office software users.

    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 to view documents in multiple windows

    1. Open the document.2. Click the title of the document with the left mouse button, and pull out the document directly by pressing the left mouse button to display the document independently. To be office specialists, you could learn how to use WPS Office online in WPS Academy.

    Writer views

    Get to know about WPS Spreadsheet for windows

    Digital tables are widely used in our daily work. WPS Spreadsheet, the best alternative to Microsoft Excel, allows you to process values, perform calculations and analyze data with high efficiency. Read this tutorial to know more about WPS Spreadsheet. · What is WPS Spreadsheet?WPS Spreadsheet is a module of WPS Office(an acronym for Writer, Presentation and Spreadsheet). WPS Spreadsheet is consistent with Excel document, which helps users to work with high efficiency. Its personal bas....

    Spreadsheet views
    Prev 123...2627 Next
    WPS Academy
    Products
    Partners