Download WPS Office for your device

We want to lock the cells after checking the table data and prevent it from being further changed. What can we do?In today's tutorial, you will learn how to use the Validation function to restrict data change.Step one, select the E column, and then add a drop-down list named checked.Click Validation at Data, and you can also use the shortcut Alt+D+L.In the Setting tab, select List at Allow, and enter checked at Source. Finally, click OK.By doing so, we can select checked in the dro....

When using WPS Spreadsheets, we can use the Fill Color tool to change the cell color. Are there any other methods to change the table style quickly? WPS Spreadsheets can realize it with its Format as Table function. 1. Select a cell range to be set. Get into the Home tab and click Format as Table to show its dropdown menu, where we can choose one from the default formats. 2. Left-click on any of the formats. Then, we can see the Format as Table dropdown menu. 3. Check the option titled....

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....

By setting hyperlinks in the document, we can click them to quickly jump to the specified pages or web pages, making it more efficient and convenient for us to browse the document. Now, we can use the hyperlink function in PDF documents by joining WPS Premium. Take this thesis as an example. We need to add a corresponding hyperlink to the title in the catalog. Click the Edit tab and the Link drop-down button, select Add/Edit Link, then hold the mouse in the area where the hyperlink nee....

PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....

In our daily work, we may encounter some table data with a vertical layout. Using the proper layout style for different tables will make it more convenient for us to check data. So how can we change horizontal data to vertical?1. First, we use the shortcut key Ctrl+A to select all the contents in the table.2. Then use Ctrl+C to copy the selected cell range. 3. Right-click and select the Paste Special option.4. Select Transpose in the popup menu. Then the horizontal data will immediatel....

We use powerful PDF in our daily life nearly every day.In our daily work, we may have encountered large PDF files. It not only affects the transmission speed but also takes up too much space. Using the compression feature of WPS Premium can quickly help you to solve this problem.Take this file as an example.1. Click the Tools tab.2. Then click Compress.3. Now a dialog box will pop up. Here, we can choose the compression level. This will determine the image quality of the compressed fil....

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