Download WPS Office for your device

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

The Page Layout function of WPS has aimed at the articles containing section breaks, the position setting of the header and footer, and the change of the measurement unit of the document. Take this document as an example. We will explain its features to all of you.· SectionThis is a document containing a section break. We can first click the Section Navigation Pane button in the Section tab, and then we can see the article is divided into four sections in the navigation pane on the lef....

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

When we use WPS Spreadsheet to enter data, we often need to convert between the general and the special format. So let's take a look at what is the general format of cells, what is the difference between them, and how we can convert them. Take this table as an example. The cell contents in the first row of this table are all in the General format. The General format means that the contents of the cells are simply expressed in numerical form. The second row of the table is in a spec....

In the process of making a WPS Presentation slide, we will unify the format of the text content for aesthetic purposes. Today, let's learn some tips for unifying the format quickly. Take this slide as an example. We can see that the font, font size, and color are different between each text. We can simply select the text box in the first line, and click the Home tab, then click the Format Painter button. Move the cursor to the second text box that needs a unified format, and click ....

We may sometimes need to convert the format of the date in the table when using WPS Spreadsheet like Microsoft Excel. At this point, by using the Date function, we can quickly generate a specific date symbol. Take this table as an example. This table contains the information on the date of birth of some students in class. We can see that the information of year, month, and day are separated in this table. So how can we convert the format quickly to know the birthdays of the students? 1....

Cell formatting is very important in data processing. We often need to set a proper cell format when entering data in WPS Spreadsheet. Let's talk about the differences between each format. Take this table as an example. Most of the cells in column B of the table are in general format. General format cells have no specific number format, which are simply displayed as numbers. In this table, most of the Column B cells are in general format. The format of cell C2 is a numeric format.....

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