Set Allow Users to Edit Ranges in a protected sheet

As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....

How to encrypt PDF files

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

Set the Table Header and Footer

In our actual work, we sometimes need to add information such as time, page number and logo in the header and footer of each page to make it more normative. So how do we set the table header and footer? In this table, we have set up the table print area. Click the Print Header and Footer button on the Print Preview tab, and in the pop-up dialog, we can set the header and footer. WPS Office has built in some basic styles, but if we need more, click the Custom Header button.There are thr....

Page setup and print-out for spreadsheets

WPS Spreadsheet could be an alternative to Microsoft Office Excel. Includes 100's of built-in formulas, pivot tables and more. Includes advanced animation, slide transitions, and support for video, images, audio and even Flash.In the last chapter, we focus on the contents related to the page setting and printout of spreadsheets, and we often encounter various problems when printing, among which four FAQs will be introduced here. · 1: My form is incomplete. What can I do?Click the ....

How to set the line numbers in WPS Writer

The usage of Line Numbers in long documents can help readers quickly find specific lines. So, how can we add line numbers? Next, I will show you the effects of setting different line number types: 1. Click the Page Layout tab and the Line Numbers drop-down button. We can see that there are different settings in the list. We can choose the Continuous Reading option to add line numbers to the entire document. 2. Choose Restart Each Page to start with number 1 on each page. 3. Choose Res....

How to sort text in WPS Writer

When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....

Print out tables

In the previous video, we learned how to set the table page and the header and footer of the table. And this video will teach us how to print out tables. In our daily work, we often need to use the print function. In the quick access toolbar, we can click Print Preview and then click the Settings button to pop up the Print dialog. Before printing, we need to make sure that the computer is connected to the printer. If we need to print two copies of the spreadsheet document, we can chec....

How to convert slides into pictures

You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. When making WPS presentation documents, what should I do if I want to convert slides into pictures in batches and save them? Take this file as an example. Click the Tools tab, then click Export to Picture. Now a dialogue box will pop up. Here, we can customize the converted picture, such as Watermark, Pages, Quality, and so on. We can choose to output By Page or output Long pi....