Download WPS Office for your device

When editing a document, we can mark specific contents quickly with the following features.· Change CaseTake this document as an example. If we want to change the case of the selected contents, click Change Case in the Home tab.In the pop-up dialog, we can select Lowercase, Uppercase, and Capitalize each word, etc., according to our needs. · Enclose CharactersIf we want to enclose a character, such as a number in the document, select it and click Enclose Characters in the Home tab.In t....

When making WPS presentation files, are you still troubled by not knowing how to match colors between the elements? This Color Schemes feature will help you. Take this slide as an example. Click the Design tab above and then click the Color Schemes button. Here, WPS Office offers multiple color schemes with a sense of design. All we need to do is choose a color scheme that fits the theme of the presentation. Tips: This feature is only valid for elements that are included with the WPS P....

When we use WPS Spreadsheet to organize the data form, we may sometimes need to add borders to the cells in the table. For example, we may use the upper and lower borders to make alphabets, employee information tables, music staff, and so on. Different data forms require different cell borders, so how can we to set the table border style? Take the employee information table as an example. 1. Select the cell area.2. Click the Home tab in the upper feature area and then the Other Borders....

When we use WPS Document to edit documents, we sometimes may want to highlight the key contents in the document. In order to do this, we can add shading colors to the text. So how can we set the shading colors? Take this text as an example. Select the sentences that need to be highlighted, click the drop-down button on the right side of Shading in the upper taskbar, select color, then you can highlight the text you want. If you don't want to select any of the colors above, click Mo....

The table shows the minimum temperature data of each month in a specific area. We can visually display the temperature changes through the color scale feature of the conditional formatting. We select the cell range B2:M2 and get into the Home tab. Click the Conditional Formatting drop-down button, and choose the Color Scales option. In the pop-up menu, we can select Red-White-Bule Color Scale.At this time, the selected table area will be marked with color. The higher the temperature, t....

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

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. Changing the orientation of printing paper is mostly necessary for our daily work. How can we set them in landscape or portrait orientation? In this table, we want to set the paper orientation and print it out. First, head to the Quick Access Toolbar in the upper left corner of the interface, then click Print Preview. If we want to print the table horizontally, click the Landscape butt....

When using WPS Spreadsheet for statistics and reports, how can we change the font in a cell? In this spreadsheet, select a range of cells. In the Home tab , we can change text settings including Size and Text Color , and add effects for the texts such as Bold, Italic, Fonts, Underline, etc. 1. Select the cells filled with WPS Academy.2. Right-click the cells, and choose Format cells in the pop-up menu. Or we can just select the cells and press the shortcut Ctrl+1.3. Click the Font tab ....