Download WPS Office for your device

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

When using WPS Writer to edit documents, we can add shading to highlight some parts of the text content. So how can we add and remove text shading? Take this document as an example. If we want to highlight the students mentioned in the notice, we can select this part of the content and click the Character Shading command button in the Home tab. By this, we can quickly add a gray shading to the selected content. Gray is the default color. If we want to delete the shading, just click the....

To remove the duplicate data when dealing with tabular data, we can use the function of Remove Duplicates. In Microsoft, we can select the needed cell range and click the Remove Duplicates button in the Data tab to remove them. In WPS Spreadsheets, in addition to removing duplicates, we can also mark them for further review and collation.1. Click the Data tab, click the Highlight Duplicates drop-down button, and select Set. 2. Then select the cell range that needs to be marked and clic....

If we find that the background color of a picture is different from the page color when editing a document, we can remove the picture's background color with one click. First, we can click the picture to enter the Picture Tools tab.Click the Set Transparent Color button, and click the background color of the picture to remove it. Tips: In addition to removing background color, we can also change the picture's color in this way.In general, we can not freely change the color of a....

When processing a table, we may find that some information contains parentheses, but it'd be troublesome to delete them one by one. Today, we're going to learn the skill to delete these parentheses and the content inside quickly. Take this table as an example. There are parentheses following the actors' names, and we want to delete these parentheses and the nationality inside. 1. Select the cell range which contains the parentheses and press Ctrl+H to pop up the Replace di....

When creating slideshows, we often download a large number of materials from websites, but some of the materials cannot be used directly, such as pictures with backgrounds.Today, I will show you a simple way to quickly remove the picture background. First, we can insert a picture with a pure white background into the slide. And select this picture to get into the Picture Tools tab.Click the Set Transparent Color button, finally click the background color of the picture.Following these....

Do you know how to lock cells in WPS Spreadsheet so that they cannot be modified by others? Take this table as an example. 1. Click the Review tab. 2. When finding that the Lock Cell button is gray, it means that the entire table is now locked. At this point, click Protect Sheet. 3. Check the Select Locked cells and Select Unlocked Cells options in the pop-up dialog box. 4. Enter a password and click OK to confirm. Then we will find that the form cannot be edited.What needs to be aware....

Do you know how to better protect the important PDF files? Today I will teach you to use the PDF encryption feature that can greatly enhance the security of documents. · 1. Set the open passwordIf you don't want others to view the contents of the PDF file at will, click the Protect tab and click Encrypt. In the pop-up dialog, check Set the open password. After setting the password, click Confirm.The next time we open this PDF file, we need to enter the correct password to view the ....