Download WPS Office for your device

Today we are going to show you how to use the cell widget in WPS Spreadsheet. The functions of it are very practical useful. Let's learn this feature together! · Convert Text to Number In WPS Spreadsheet, the text formatting is quite special. 1. It cannot be directly converted to other formats. 2. The text formatting is aligned to the left, and other formattings are aligned to the right. Take this table as an example. We now need to change the date in the table to another type. By ....

You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint. Take this presentation as an example. In order to better explain the contents, I will insert a table into this slide. Click Object in the Insert tab. A dialogue box will pop up, where we could select Create new or Create from file.In the Create new interface, we can select different types of blank documents at the Object type, but we need to edit them manually. In the Create ....

When you need to print a table at work, sometimes you may find that the table cannot be printed on one page. And also when you need to output a table as a PDF file, it sometimes will be divided into several pages. In this case, you can use the Page Break Preview feature of Spreadsheet. It can help you to preview the paging area. Take this table as an example. Click the View tab of the tab feature panel and then the Page Break Preview button. In this page break preview interface, you ca....

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

Take this table as an example. In order to better supplement the content of the table, we can insert the objects we need in the table. First, select cell F2, click the Insert tab, and the Object button. We can choose Create new or Create from file on the left side in the pop-up dialog. In the Create new interface, we can select different types of blank documents in the Object type area, and we can edit them manually.In the Create from file interface, we can insert local documents, appl....

When editing a document, we sometimes insert a lot of pictures. We usually back up images in case they get lost.Then, do you know how to download an package of images at a time? For example, in this document, many pictures are inserted into the document, and it is a waste of time to save them one by one. Here I'm going to introduce you a very simple skill. Click the Menu button in the upper left corner, and click the Save as the button to pop up the dialog box.In File Type, select ....

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

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Our spreadsheet can be encrypted to protect privacy. Security in the Options allows us to do so. Take this table as an example. We click Menu and select Options in the drop-down list. A dialogue box will pop up. Click Security, where we can find File encryption options for this workbook" and File sharing options for this workbook. If we want to encrypt....