Download WPS Office for your device

Cell formatting is an important feature of spreadsheets. So today, we will briefly go through how to format cell values. Number formatting can be simply understood as a digital form that can be used for calculations.Take this table as an example: now the data in the cell is in text formatting. If using the SUM function to do calculations, we would find that the data in text format cannot be calculated. At this time, we need to convert the data into a number formatting that can support ....

When we edit a document, we only need to press the Enter key on the keyboard to wrap text. When we edit spreadsheets, we press the Enter key to edit the cells in the next line, then how can wen wrap text in a cell? This video could help to solve the problem of Wrap text in a cell and could be also used in Microsoft Office Excel and Openoffice. The first method is to use the shortcut key Alt + Enter ; we can wrap text in a cell as we need. The second method is to click the Home tab and ....

In our life and study, we often need to copy the text content of different pages to WPS Document in order to save records. Sometimes copying and pasting text into WPS Document can lead to a messy layout of the content, and also the font size may not be uniform. In this case, we can use the Clear Formatting function. It can clear all the formats of the selected text and only keep the unformatted text. Take this document as an example, the text has a messy layout, and also the font size ....

When you use WPS Document, have you ever encountered the situation that you need to reformat after copying text into a document? The Text Tools in WPS Document can help us to format paragraph layout more efficiently. Now we are going to show you how we can use text tools to quickly format paragraphs. Take this press release as an example. We can see that the layout of the text is really messy. So how can we use Text Tools to quickly format the paragraphs? When encountering this kind of....

When we are editing a document, we may sometimes find the formatting of the document is not uniform. Or sometimes, we may want to quickly apply the same formatting of one paragraph to another text. All these situations can be easily solved with Format Painter, which could be also used in Microsoft Office Word and Openoffice. Take this document as an example. After we finish setting the text formatting of the title, we now want to copy all formatting of the text to the title below.1. Se....

Do you know how we can convert a number into the fraction format?There are two available methods to set fraction format in WPS Spreadsheet. First, select the range of the table, head to the Home tab, find the setting button in the shortcut menu, and set the Fraction format.Alternatively, we can select the desired range of cells, and right-click Format cells, whose shortcut key is Ctrl+1.Locate Fraction in the category list, and choose from different types of fractions in the Type area....

When using WPS Spreadsheet to process data, we can customize cell format with codes. In this video, you will learn about several practical codes for custom cell format. Take the worksheet here as an example. Select Column E, right-click on it and choose Format Cells in the menu. You can also use the shortcut key Ctrl+1 to pop up the dialog. Get into the tab of "Custom". Then we can see "m/d/yyyy" in the input box. Here "m", "d", and "yyyy"are respectively placeholders for month, day, a....

If you want to save multiple pictures in a table, a common practice is to save them one by one. It will be very troublesome when there are a large number of pictures. Today, we will learn a quick tip to export pictures in batches. Taking this table as an example, we can see that there are many pictures in the table. First, change the suffix name of this table file in accordance with the suffix of the zip file. Here, we change the .xlsx format to .rar format and then decompress the file....