211 results for windows keyboard shortcuts
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
211 results for windows keyboard shortcuts
How to customize text shortcut keys
01:33How 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....
Use Validation to restrict date entries
01:10Use 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 ....
Ctrl+E smart filling
02:50Ctrl+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....
How to use the selection feature
02:58How 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....
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.
Make a countdown calendar in WPS Spreadsheet
01:37Make 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....
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.
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....