- All Tutorials
- Video Tutorials
- Quick Tutorials
51 Search results
Use the fill handle to quickly enter data02:59
Use the fill handle to quickly enter data
AutoFill can help us quickly enter some regular data, which is an essential skill in using WPS Spreadsheet to deal with different data. It includes Fill Numerical Value, Fills Data, Fill Text, Custom Text Filling, and Fill Formulas.Take this table as an example. If we want to fill in the numbers 1 to 10 in column A, select cell A2 and move the cursor to the lower right corner of cell A2. At this time, the cursor will turn into a small black solid cross. Press and hold the left mouse bu....
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....
How to turn off automatic numbering in WPS Writer
When editing documents, we sometimes don't want WPS Office to automatically number list for us every time we press the Enter key. So how can we turn off automatic numbering?1. First open the file in WPS Writer.2. Click the Menu button in upper lefter corner.3. Then select Options in the drop-down menu. Now a Options dialog box will pop up.4. Click Edit → and then check Auto numbered lists.5. Finally click OK.This skill could also be used in Microsoft Office Word and OpenOffice.
How to insert a table in WPS Presentation01:47
How to insert a table in WPS Presentation
When creating a presentation in WPS Office, sometimes we need to insert a table for data demonstration. How can we realize it? Take this PowerPoint as an example. Get into the Insert tab and click the Table dropdown menu. Then drag the cursor to decide the table size. This method allows us to create a table with 10 columns and 10 rows at maximum. If we want to insert a bigger table, choose Insert Table. In the Insert Table dialog, we can decide the numbers of columns and rows. Enter t....
Table rows, columns, cells, and status bar03:27
Table rows, columns, cells, and status bar
In the last video, we just talked about the worksheet and workbook in the WPS Spreadsheet. So in this video, we will learn about the Spreadsheet interface elements: rows, columns, cells, and those tools in the lower status bar.On the left is the row, and the marked numbers 1, 2, and 3 are called the row number. Above is the column, and the marked numbers A, B, and C are called the column number. The grids in the middle are called cells.When expressing the position of a cell, we use col....
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.
Use the ROUND function to round decimals quickly01:57
Use the ROUND function to round decimals quickly
In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly. Take the decimal in the B3 cell as an example.1. Place the cursor in C3.2. Click Insert Function.3. In Math and Trig, select the ROUND function. The pop-up dialog box has two parameters. Number is the numerical value to be rounded, and Num_digits refers to the digits to be used for rounding. If the Num_digits is greater than 0, then th....
How to insert audio in WPS Presentation01:36
How to insert audio in WPS Presentation
When giving a speech, we often need background music to set off the atmosphere. So how do we insert audio when making slides? Take this slide as an example, click the Insert tab above, and then click Audio. Here we can see Insert Audio, Link to Sound, Background Music and Link Background Music these four options. The difference between Audio and Background Music is that when we choose the Audio option, we can only hear the music when we play the slideshow where the music is inserted. B....