- All Tutorials
- Video Tutorials
- Quick Tutorials
320 Search results
How to add a stamp in a PDF file01:42
How to add a stamp in a PDF file
We use powerful PDF in our daily life nearly every day.In our daily work and study, we can insert a stamp in the PDF file to indicate that the file has already been reviewed.Now we are going to introduce the Stamp WPS Premium feature.Click the Comment tab and then click Stamp. Here, WPS has provided us with a large variety of presets. We can click the needed stamp style and place it in the appropriate area of the page. We can also customize the stamp. Click Click to Add, then the Add S....
How to add gridlines and guides in WPS Presentation01:31
How to add gridlines and guides in WPS Presentation
When we make a slideshow, in order to achieve a good typographic effect, we generally add guides and gridlines to the page. Take this slide as an example. It is difficult for us to center the title without smart assisted alignment. At this point, we only need to click the View tab above, then click the Grid and Guides button, finally check Display smart guides on screen. With the help of smart guides, centering the title becomes simple. Learn to use guides, and we can achieve more type....
How to add a watermark02:14
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....
How to use the Excel MID function01:54
How to use the Excel MID function
When using WPS Spreadsheets to process data, sometimes we need to catch part of the data from a series of numbers. We can use the MID formula to realize it, to catch up a certain length of characters from a series of numbers. In this example, there is a list of phone numbers. The MID function can extract the long series of numbers, keeping the last seven numbers when removing the first three characters. Select cell D2 and click the Insert Function to pop up the Search for a function d....
Multiple merge methods to cells03:17
Multiple merge methods to cells
When we use the WPS Spreadsheet, we often need to merge and combine multiple cells. Merge and Center in WPS spreadsheet offers multiple merging methods. We will explain in detail how to use this function. · Merge and CenterSelect the cell area to be merged, click Home and find the drop-down menu of Merge and Center, and select Merge and Center or press keyboard shortcut Ctrl+M. In this way, the selected cells can be merged into one cell and displayed in the center. · Merge CellsSelect ....
Format Cells Locked and Hidden01:21
Format Cells Locked and Hidden
When working with spreadsheets, what should we do if we want to hide and protect the formulas in the cells? Take this spreadsheet as an example, click the Review tab, then we can box the cells containing the formulas, right-click for the pop-up dialog, select Format Cells. Its shortcut key is Ctrl+1.Next, click Protection, check Locked and Hidden at the same time, and click OK. We sometimes find the Locked option in the dialog settings displaying as a black square, which represents unc....
How can we change the font in a cell01:09
How can we change the font in a cell
When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell? In this spreadsheet, select a range of cells. In the Home tab , we can change text settings including Size and Text Color , and add effects for the texts such as Bold, Italic, Fonts, Underline, etc. 1. Select the cells filled with WPS Academy.2. Right-click the cells, and choose Format cells in the pop-up menu. Or we can just select the cells and press the shortcut Ctrl+1.3. Click the Font tab ....
Merge and split table cells in WPS Writer01:09
Merge and split table cells in WPS Writer
Today we are going to learn how to merge and split table cells in a document.Take this table as an example.· Merge cellsHere, we can merge cells. Select the cell in the first column and click the Merge Cells button in the Table Tools tab to merge the cells. · Split Cells1. If we want to divide a cell into several cells, we can select the cell that needs to be split. 2. Click the Split Cells button in the Table Tools tab.3. In the pop-up dialog box, we can set the number of columns and ....