Download WPS Office for your device

When using WPS Writer for typesetting, we often need to adjust the spacing between characters. How can we adjust the character spacing?Take this document as an example. Select the text content, click Home in the upper menu bar, and choose Settings → Font. Then we can see the Font window. We can also press the shortcut key Shift+D to pop up the dialog. Get into the Character Spacing tab, and change the setting of Spacing. Here, we can choose one of the three default character spacing e....

When making slides in WPS Presentation, we often need to adjust the spacing between characters. By this, we can perfect the layout and make our slides easier to view.So how can we adjust the character spacing of the text content in slides? Take these slides as an example. First, click to select the text that needs to be spaced. Click the right mouse button, then click Font. Finally, click the Character Spacing tab. The Spacing is Normal by default. We can set the character spacing as E....

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

After we finish editing the text content, we need to adjust the font size and line spacing of the text in order to make it easy to read. So how can we adjust line spacing of the text? Take this document as an example, select all the text content, then click the Line Spacing button of the Home tab. Users can select the amount of line spacing here according to their needs. If there are is no proper options, users can also set line spacing by themselves. 1.Click the Line Spacing button o....

Here is a form recording the personal information of staff. How can we calculate the staff number for each department?We can combine the LENS and SUBSTITUTE functions to realize it. Before starting, let me introduce the LEN function. It can return the character number of the text.Select cell A4. Go to the formula editing box for the Insert Function button, and choose the LENS function.Since we want to know the character number in cell A2, we need to enter “A2” as the TEXT parameter. Cl....

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