How to insert rows and columns in the table

After we use WPS Office to open the spreadsheet, we first select the place where we want to insert rows and columns.Then right-click to select Insert. We can also enter the rows and columns that we want to insert in the input box.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to create a new blank file

In WPS Office, we can create a new blank file by the following ways:1. Open WPS on our computer. Then we can see the Home page of WPS Office.Click the New tab in the navigation pane, then the New tab page will pop up. Click Blank in Template Resource to create a new blank file.2. After opening WPS on the computer, we can also click the + on the right side of the tab bar to create a new file.3. Click Menu at the upper left corner, and then click New to create a new file.4. Use the short....

How to undo and redo an operation

· UNDOTake this document in WPS Writer as an example.First, we need to use WPS Writer to open a document. After we edit the document, we can click the Undo bottom in the upper left corner of the page. We can also use the shortcut key Ctrl+Z to undo the operation. Click the inverted triangle button on the right side of Undo. We can see the operations that we have just did on the document.By selecting one of the operations, we can undo as many actions as needed with one click. · REDOIf u....

How to quickly open other files in WPS Office

Take this document in WPS Writer as an example. It is also the same in WPS Presentation and WPS Spreadsheet.After using WPS Office, open the file, and click the Menu button in the upper left corner. Then select the Open button in the drop-down menu. We can choose the file we want to open in this popup window. Then click Open.To be office specialists, you could learn how to use WPS Office online in WPS Academy.

How to quickly merge and center cells in WPS Spreadsheet

After we use WPS Office to open the spreadsheet, select the cell that needs to be manipulated.Then click the Home tab and find the Merge and Center button. By clicking this button, we can quickly merge and center cells. Its shortcut key is Ctrl+M.This skill could be also used in Microsoft Office Excel and Openoffice.

How to set borders for cells in WPS Spreadsheet

After we use WPS Office to open the spreadsheet, select the cells that need to add borders to.Then just click the All Borders button in the Home tab. By this, we can apply borders to the currently selected cells.If we want to adjust the settings of the borders, we can click the drop down button of All Borders. Then we can select the border style according to our needs in the drop-down menu.We can even click More Borders to customize borders in the popup box. Then click OK to apply the ....

How to add highlight color to the text

Take this document in WPS Writer as an example. If we want to make the text look like it was marked with a highlighter pen, first select the text that we want to highlight. Then just click Text Highlight Color in the Home tab. We can choose the color we want here. To be office specialists, you could learn how to use WPS Office online in WPS Academy.

How to use the heading style in WPS Writer

First, we use WPS Office to open the document, and then select the text to be manipulated. Click the Home tab and select a heading style as needed, such as Heading 1. As shown in the figure, it can be seen that we have successfully applied the selected heading style to the text. Note: There is a certain logic level in the heading style feature. For instance, Heading 1 is the chapter title. Heading 2 is the sub-title of the chapter. To be office word advancers, you could learn how to us....