How to lock columns and rows in a table

1. Use WPS Office to open the table.2. Click the Review tab → and then click the Lock Cell button.3. Now click the Protect Sheet button, then the Protect Sheet box will pop up. Uncheck Insert Columns and Insert Rows.4. Now we will find it impossible to insert rows and columns in this table.This skill could be also used in Microsoft Office Excel and Openoffice.

How to copy and paste text from PDF to word?

1. Open your document in WPS PDF, and select the text that you want to copy.2. You can right click the text and click Copy, or use its shortcut key Ctrl+C.3. Open your word document and paste it there. Its shortcut key is Ctrl+V.Note that the content in this PDF should be in the form of text, but not image. 3. To paste only the text without it original format, you can paste it by clicking Keep Text Only. To be office specialists, you could learn how to use WPS Office online in WPS Ac....

How to export a PPT file to a PDF file

1. Use WPS Office to open slides.2. Click the Tools tab → the Export to PDF button.3. In the pop-up dialog box, we can set up the Export range, Save Path, Export Type. We can also check Backup to Cloud or Open after export.4. Finally, click the Export to PDF button. You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.

How to automatically adjust table columns in WPS Writer

1. Open the document with table in WPS Writer.2. Click the table. Then we will automatically jump to the Table Tools tab interface.3. Click the AutoFit button. Then a drop-down button will pop up. Here, we can select AutoFit to Window or AutoFit to Content.AutoFit to Window: WPS will adjust table columns according to the width of the window. AutoFit to content: WPS will adjust table columns to fit the size of the content. This skill could also be used in Microsoft Office Word and OpenO....

How to italicize the selected contents

Take WPS Writer as an example.First, select the contents that need to be italicized.Then click the Home tab, and then click the Italic bottom. By this, we can easily italicize the selected contents.We can also use the shortcut key Ctrl+I to italicize. To be office specialists, you could learn how to use WPS Office online in WPS Academy.

How to compress PDF quickly in WPS Office

Sometimes the files are too large to upload or send to other people, so we need to compress the file. PDF is a commonly used format at work. In this free tutorial, you will learn how to compress PDF files within only several steps. Without further ado, let’s begin. · Steps to compress PDF quickly in WPS Office.1. Open the PDF file you need to compress in WPS Office.2. Head to the Tools tab, and click Compress to pop up a dialog. In the Kingsoft PDF Compression dialog:3. Check the PDF f....

The RAND Function in Excel

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. · Description:With Rand Function, you can return a random number between 0 and 1, and each time you recalculate them, they will return new values. · syntax:RAND( ) · ArgumentsNo arguments for the RAND function. · Example:1. Open your table in WPS Spreadsheet.2. Select a blank cell where you want to add a random number. Click the Formulas tab > Insert F....

How to save files to My Cloud Files?

There are two methods for you.Option 1:1. Open WPS Office, and click Open in the WPS home page.2. Click My Cloud Files, and click the Save to Cloud icon → Upload Files. Then select your file and click Open. Option 2:Here we take WPS Writer as an example.1. Open the document you need to save to Cloud.2. Click the Tools tab, and click Save to Cloud Docs. In the pop-up dialog, you can select a concrete position, rename the file and set the file type. Then click Save. For all, easy your w....