Create a countdown calendar & Insert current time and date

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently. Today, we are going to introduce basic usages of three commonly used date functions. They are namely the TODAY function, NOW function, and DATEDIF function. We can use the date function to insert the current date and time quickly. Also, we can use this function to update it in real-time. We can also make a countdown calendar with it. · ....

How to add a watermark

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.We often see unique watermarks printed on the back of some files. Adding a watermark can not only prevent others from embezzling but also can help us to indicate the source of the article. So how can we add a watermark to a document?To show the source, we need to add the watermark of WPS Academy to the following documents now.1. After cl....

Use the Mail Merge function to input tabular data quickly

WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types. Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge fun....

Text direction in WPS Presentation

When inputting text in WPS Presentation, we find the text is horizontal by default. To make a slide more elegant, we can use the Text Direction function to change its layout. · Text DirectionTake the first slide of this presentation as an example. Here is a horizontal text. 1. Click the text to jump to the Text Tools tab, click the Text Direction drop-down button, and we can select Vertical.For a presentation document, text and text boxes are inseparable and interactional, so we can m....

More features in Picture to Text

Both WPS Writer and Microsoft Word have the function of Converting pictures to text. What are the differences between them? Microsoft Word itself does not support the OCR function. If you want to convert Picture to Text, you need to open another application, "OneNote."1. Copy the picture to OneNote, and right-click it to select Copy Text from Picture.2. Finally, paste the text into PowerPoint or Word as needed. In WPS Writer, it is much more convenient to do the conversion in the docum....

How to split sheets quickly

In WPS Spreadsheets, there are two ways of splitting sheets: Split Sheets By Content and Split Books By Sheet. First, Split Sheets By Content.Take this table as an example. We want to split this table into multiple sheets by month. Click the Data tab, click the Split Sheet drop-down button and select Split Sheets By Content. The default Split area is the whole table. Check My data has headers to make the split sheets have titles. Since we want to split the table by month, we select "Mo....

How to print the notes in PDF

We may add notes to important content when reading a PDF document. Do you know how to print them out?Take this document as an example. We have added several notes on the page. 1. Click Menu and click Print.2. On the right of the pop-up dialog, select Document and Note Contents in the "Print content" drop-down button.3. Then the marks of notes are displayed in the preview window. However, we still fail to print out the contents in the text boxes. What can we do? There are two methods fo....

How to use the Review feature

If other people revise a document, we can use the review feature to view the revisions. Take this paper as an example. It is revised by two people.If we only want to read Miss Chan's comments, here are the steps. In the Review tab, click the Review drop-down button and click Reviewers. Check your desired reviewer.Then Miss Chan's comments are displayed on the right. Sometimes, a paper may go through multiple revisions and comments.If we only want to read the latest comments, we....