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, etc. Today, we will learn Editing settings in WPS Spreadsheet. A personalized editing style will make the table easier to edit and read. First, click Menu in the upper left corner of the table, select Options, and click Edit in the pop-up dialog box to get into the Edit Settings interface. Here I will elaborate on how the functions of Edit Settings can be put int....

When we are editing documents, we sometimes need to add additional information such as company name, logo, date, etc. in the header and footer. The additional information ensures the integrity of the document. This video of Basic settings on footer and header could be also used in Microsoft Office Word and Openoffice. Steps:Take this document as an example. 1. Click the Insert tab, and then the Header and Footer button in turn. 2. Click the header text box, and enter “Kingsoft Office”....

When designing the layout of the document, we often need to set the text font, paragraph settings, and heading style.In WPS Writer, these frequently used typesetting tools are collected in the Settings button under the Home tab. l Font settingTake this document as an example. We need to set the text format.Press the shortcut Ctrl+A to select the whole document, and click Font.We can change Font, Font style, Size, Color，and other parameters of the text.In the Effect area under the Font....

The function of action settings in WPS Presentation allows us to set actions for graphic images and content text in slides. We will be the amazing reporter with WPS Presentation, which could alternative to Microsoft powerpoint. So, how can we use this function? Take the slides as an example. First, select the picture, click the Insert tab above, and then click Action Settings. There are two ways to trigger the action, namely mouse click and mouse over, we can choose an option according....

When we are using WPS Document to edit text, we sometimes need to put a border around the text, or we may also want to add a special shading color to the text in order to highlight the keywords. So now the problem is, how can we do that? Take this resume as an example. If we want to highlight the border, we should select all the content first, and click the Home tab, and then lick the Outside Borders drop-down button. Here, we can see different styles of border lines. Click Borders and....

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

When using WPS Writer, how can we customize the font for a document? In the toolbar of Home, users can simply set the Font, the Size, etc. For advanced settings for font, click the drop-down button next to Menu, choose Format and Font, then you can see the interface for Font setting. You can also press the shortcut Ctrl+D to pop up the dialog. In this interface, we can change the settings for Latin text font and Asian text font, which include fonts, Font style and Size. You can also c....

In the process of using WPS Office, we can set the overall view effect of WPS components for personal use. Take the components in WPS Writer as an example. Click Menu and choose Options. At this time, a dialog box will pop up. In the left tab, the first one is View. In this interface, we can set Show, Print, options, Formatting marks and Ribbon options. +In the Show box, we can set Status bar, Mini Toolbar. +In the Print options box, we can set the content that needs to be displayed. F....