Download WPS Office for your device

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

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

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

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

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

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

Are you still formatting the cells one by one? Use the format painter to quickly apply the cell format, which greatly improves your efficiency. Take this table as an example. We want to copy and paste the format of the first-row cell range elsewhere. Select the cell range in the first row, click the Home tab, then click the Format Painter button, and select the cell range you want to apply; click once. In this way, we can apply the cell formats of the first row to other cells. Then how....

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