- All Tutorials
- Video Tutorials
- Quick Tutorials
20 Search results
Create a countdown calendar current time and date02:14
Create a countdown calendar 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. · ....
Use text tools to format paragraphs layout quickly01:37
Use text tools to format paragraphs layout quickly
When you use WPS Document, have you ever encountered the situation that you need to reformat after copying text into a document? The Text Tools in WPS Document can help us to format paragraph layout more efficiently. Now we are going to show you how we can use text tools to quickly format paragraphs. Take this press release as an example. We can see that the layout of the text is really messy. So how can we use Text Tools to quickly format the paragraphs? When encountering this kind of....
Use the ROW function in WPS Spreadsheets for row numbering03:03
Use the ROW function in WPS Spreadsheets for row numbering
When using WPS Spreadsheets to process data, how can we deal with the worksheets without numbering or those with disordered numbers? Are there any convenient ways to number the rows while the numbers are not supposed to get disordered when certain rows are removed? The ROW function can realize it. The complete ROW formula is =ROW([Reference]). Here Reference can refer to a single cell, a cell range, or nothing. Here is the introduction to the two options of using the ROW function. · O....
How to update the table of contents
When using WPS Writer to process word documents, how can we update the table of contents that is automatically created？ 1. Open the Word document with WPS Writer. 2. Select the contents in the interface → the Reference tab → click Update TOC. No matter you are a student, teacher, or business professionals can create and edit documents efficiently by WPS Writer as text editors. Easy to use as Microsoft Word.
How to update only the page number in a table of contents
1. Open the document we want to edit in WPS Writer.2. Click on the table of contents.3. Click References tab → and then click the Update TOC button.4. Now a Update Table of Contents small dialog box will pop up. Check Update page numbers only.5. Finally, click OK. This skill could also be used in Microsoft Office Word and OpenOffice.
How to insert time in WPS Writer
· Insert time in the text:1. Use WPS Office to open the document, and place the cursor where you want to insert time.2. Click the Insert tab → the Date and Time button.3. In the pop-up dialog box, we can select the date or time formats we want to insert in the document.4. We can check Update automatically to make time update automatically.5. Finally, click the OK button. · Insert time in the header or footer:1. Use WPS Office to open the document, and place the cursor where you want to....
Edit text contents in PDF01:54
Edit text contents in PDF
Do you know how to edit a PDF? What if we need to correct something wrong in a PDF?Go to WPS Premium, and you will be able to use the editing feature. For example, if you want to edit the title, get into the "Edit" tab, and click the "Edit Content" drop-down menu. By checking the "Show Text Boundary" option, you will see the text contents in the PDF presenting in text boxes.Click the text box, then you can edit the text content in the PDF. Right-click to copy, paste, cut, or delete the....
How to highlight the content of a PDF file02:04
How to highlight the content of a PDF file
When reading the PDF file, we sometimes may encounter some critical text content. To facilitate our reading, we can highlight the needed text. Today, we will show you how to use the highlighting feature of the PDF. Take this PDF file as an example. Click the Comment tab, then click the Highlight drop-down menu. Here, select the color we like, then the selected text will be highlighted.If we want to highlight an area, we can use the area highlighting feature. Click the Highlight Area dr....