1. Learned the basic operation interface of WPS Spreadsheet.2. What is the difference between a workbook and a worksheet?3. know the table rows and columns, how to correctly adjust the row height column width?4. What is a cell, what is the cell area, how do we quickly locate the specified cell or cell area?

When using WPS Spreadsheet to create tables, we may want some of the cells in the table to have borders and some without borders. To do this, we can use the Draw Border functions to customize the drawing of cell borders, which could be also used in Microsoft Office Excel and Openoffice. Take this table as an example. 1. Click the Home tab. 2. Click the Draw Border drop-down button. 3. Select the Draw Border option in the drop-down menu. The mouse cursor will turn into a brush style. 4.....

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 using WPS Presentation, we sometimes add a header and/or a footer to make the slides look more professional. How can we realize it? In this example, get into the Insert tab, and click the Header and Footer button. Then, we will see the two tabs of Slide and the Notes and Handout in the Header/Footer dialog. · The Slide tabHere we can insert the date and time, footer, and page number in the footer, which are respectively positioned in the bottom-left, -middle, and -right areas of t....

In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need? Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1. In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format o....

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 Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some tips to delete duplicates. · Option OneSelect a range of cells. Get into the Data tab, and click the triangle next to Highlight Duplicates. Pick Set from the drop-down list. Duplicated cells within the selected range will be highlighted. To clear the highlight color, we just need to click the Set button. · Option Two Select cell range (A2:C14). Get into....

The Presentation Tools button serves as a quick and convenient assistant in WPS Presentation, helping us to set the slides easily in a short time. So how can we use Presentation Tools? Click the Design tab on the top, and click the Presentation Tools drop-down button. We can see four options here: Replace Fonts, Batch Font Settings, Customize Text Formats and Insert Picture to Multiple Slides. · Replace Fonts:The Replace Fonts option helps us to replace one font with another throughout....