There are 8 free training tutorials of how to use office suite for WPS
How to free download WPS office app on iOS
Welcome to WPS Official Academy! Are you interested in WPS office, commonly called WPS Office? Do you want to use WPS office on mobile but have no idea how to download? In today's tutorial, we'll introduce how to download WPS office app on iOS. l Steps to download WPS office app on iOS1. Open the App Store on your device.2. Enter WPS Office on the search box and find WPS Office in the search results. 3. Click to download and install the app, and then WPS Off....
How to make an excel file read only
How to Make an Excel File Read Only: The Ultimate Guide Keyword: how to make an excel file read only Do you need to make an Excel file read only? Perhaps you have a document that you don't want others to be able to edit, or maybe you just want to make sure that no one can delete any of your data. Whatever the reason, it's easy to do! In this guide, we will show you how to make an Excel file read only in just a few simple steps. Keep reading for more information. One of the be....
How to convert dates to month, year and day in excel?
There may be times while working with date-specific data that you need to identify the weekday, month, or year that corresponds to a certain date. For example, you might be interested in learning the day of the week instead than just the date or you want to convert date to month. Excel automatically detects the format and changes any date you enter in cell into a date cell. Excel is thus aware of which parts of the date you supplied correspond to the month, the year, and the day. This ....
How to view the recent files in WPS Office
1. Open the WPS Office.2. Click the Home icon in the upper left corner and click Recent, then we can view the recent files.3. Click More Documents in the bottom right corner to view more recent files. To be office specialists, you could learn how to use WPS Office online in WPS Academy
How to activate and stop Automatic Numbering in Word?
By default, if you enter a number at the beginning of your text, the system will automatically assign numbers for the following text. In some cases, however, those numbers are unwanted guests. So how can we activate and stop automatic numbering? · To activate Automatic Numbering: Type a number followed by a period (like 1. or 2. ) according to your needs in the texts. Press the Enter key and the rest of your text will be assigned with numbers at the beginning of each paragraph. By doin....
How to change portrait to landscape in Excel
Changing the orientation from portrait to landscape in WPS Spreadsheet is the ultimate way to solve the headache of some incomplete printing pages, especially for sheets with multiple columns. If you want to know how to change the orientation of printing paper, here’s how. · Example of changing portrait to landscapeTake this student information sheet as an example. Newcomers to WPS Spreadsheet may get frustrated at the incomplete table on the Print Preview page. To solve this, please ....
How to enter text vertically in cells
In most situations, when entering text context into a cell WPS Spreadsheet, the characters are arranged from left to right. How can we type vertically in WPS Spreadsheet?1. Right-click the cell → choose Format Cells in the dropdown list 2. Get into the Alignment tab in the Format Cells dialog, and check the Vertical text box. Then, the characters would present vertically.WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot ta....