Download WPS Office for your device

The boss needs us to enter an employee information form, but Alice's work number is never always not displayed correctly. As long as we enter a number starting with “0”, the spreadsheet always hides the preceding “0” by default, so what should we do? In this cases, we just need to convert the cell to text formatting.1. Select a cell, to make a prompt corner mark present. 2. Click the prompt corner mark. Then, the cell will quickly switch to text formatting.Here is another method to....

When calculating data with WPS Spreadsheet, the error message #DIV/0! will come to us from time to time.What caused the mistake? And how can we remove it? Take this table as an example. For example, when we want to calculate the unit price of pencils, we can enter =C3/D3 in cell E3, and the calculation result will show the error value #DIV/0! This is because, in this division operation, the denominator is 0, which leads to the calculation error. When we drop down and fill in the calcul....

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

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

When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

Optical character recognition, also called OCR, is practical to extract text information from a picture. It can also maintain the content layout in the source picture. The first example will show you how to extract text from a picture.1. Go to the Tool tab and click OCR.2. In the pop-up dialog, click Screen Capture to take a screenshot of a selected area.3. Choose Extract text only.Then, we can get the text from the dialog on the right-hand side.If you've joined WPS Premium, you ca....