If you have a worksheet for others to fill in, while you don't want certain important data to be modified, the Protect sheet function in WPS Spreadsheet can help you. To lock the entire sheet, get into the Review tab first. If you see the Lock Cell button grayed out, it means that the entire sheet has been locked by default.Next, click the Protect Sheet button, set the password, and click Confirm the setting. Then the sheet formally enters a locked state, and the sheet cannot be ed....

PDF is a common file format at work, which cannot be easily modified. If we want to delete a part of the page quickly, we can use the Crop function for WPS VIP members. Take this file as an example. We can see the proportion of the text and margins is obviously out of harmony. How can we adjust it? · Step 1You can find crop page in the Edit tab. Also, you can click crop page in the Page tab. When the dotted lines appear around the page, click Auto Cropping, and WPS Office will automati....

This lesson summarizes the printing problems commonly encountered in the workplace1. How to make the printer obedient, forms are printed on a sheet of paper2. How to select the designated printing area3. When the form file is very long, how to set each page has a title line4. how to set the header and footer, so that your document more professional

We can use the caption feature to number and annotate images, charts and other contents referenced in a document. So how do we use this feature? We take the image in this document as an example. Select the image, click References, and then click Caption to get a pop-up dialog.Click the Label pull-down to select the label you want. If none is available, you can click New Label to customize a label such as a Picture.Then select the Position of the caption. Click the Numbering button, you....

A well-formatted presentation file can better your speech, and properly adding animation effects can help capture the audience's attention. So how can we customize the animation? Take these slides as an example.1. Click the Animation tab at the top, then the Custom Animation task pane will pop up on the right side of the screen. Now we click Selection Pane.2. In the Selection Pane task pane, we can see all the elements of the current slide page.3. Click the eye icon on the right to....

After inserting a picture in the document, to perfect the layout, we will adjust the position of the picture in the process of typesetting. Take this document as an example. If we want to move the picture to the lower right corner of the page margin, click the picture first. Then click the Layout Options button in the upper right corner of the picture. And then click View More, now the Layout dialog box will pop up. WPS has provided us a large variety of alignment methods in the Positi....

Do you know how we can shut down the automatic numbering function? Here are three different ways to cancel automatic numbering. WPS Office is equipped with the automatic numbering function by default. When we enter the numbered text and press Enter, serial numbers will be automatically added in the next paragraph , and the Numbering button in the function area is gray.However, a lot of times, we don't need automatic numbering, so how can we solve this the problem? In this case, we....

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....