There are 8 free training skills of how to use office suite for WPS
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 add cells in excel with formula
How to add cells in Excel? How to add cells in excel? Excel is a versatile tool that you can use to perform many different types of tasks. If you have forgotten to add important information to your worksheet, you can quickly and easily add more cells. Adding cells is inserting one or more cells between existing cells. If you want to know how to add cells in excel, you can continue reading. How to add cells in excel basic form? To learn how to add cells in excel 2016, you will need to w....
How to insert hyperlink in word
Main keyword: how to insert hyperlink in word How to insert hyperlink in word 2019 There are many ways to make a document, depending on the tools used and the added elements. Every document should have links, but you must know how to insert hyperlink in Word to use them. Once you understand how to insert hyperlink in Word, you can use them in various ways in the same Word document. By integrating these elements, you can make your document readable, organized, and functional. How to ins....
What is WPS Office? Enumerate 5 reasons why people choose it
Are you searching for WPS Office? Welcome to WPS Official Academy to check the convincing reasons why we genuinely recommend you to download and use WPS Office as your office software. It only takes you five minutes to read this article, and then you will have a better knowledge of WPS Office and its powerful features.lWhat is WPS Office?WPS Office is a lightweight, feature-rich comprehensive office suite with high compatibility launched by the Kingsoft team. As a handy and profession....
How to add a column in excel on mac
How to add a column in Excel? Learn how to add a column in excel is a simple procedure that most people know how to do. It is a common task for everyone who works in Excel, and there are different ways that you can add or insert a column in your Excel table. If you are a beginner and do not have basic knowledge of Excel, you are in the right place. Below you can find 3 ways how to add a column in excel correctly. How to add a column in excel? To learn how to add a column in excel 2016,....
How to count cells by color in Spreadsheet?
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, we will highlight duplicate cells with custom colors to identify data easier. But how can we count them? In this tutorial, you will learn how to highlight duplicate cells by color.1. Open your table in WPS Spreadsheet.2. Click the Home tab, then select the Find and Replace button or use the shortcut key Ctrl+F. 3. In the pop-up dialog, click....
Insert watermark in Word doc online
Microsoft Office has become the weapon of the most dedicated workers, and even though the program is simple, it also has great potential. With a word, you will be able to create a professional document using the font you like the most, and when you have finished it, you will add a watermark. However, you will need to know how to insert a watermark to complete this process.The watermarks in the document will allow you to avoid plagiarism, copyright, or simply promoting the company. Thes....
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 ....