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 use Resume Master in WPS Office

After we open WPS Office, find Resume Master in the navigation bar on the left. Click the Resume Master button. Then find the red button Create My Resume Now on the new page. After clicking, we will come to the information filling interface. Users can fill in the information they need in their resumes here. Then Resume Master will help users automatically generate their resumes. At the same time, users can also preview their resumes in the Preview and Edit window on the right side of t....

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 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 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 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 search and use templates in WPS Office

After we open WPS Office, find + in the top tab bar and click it.Select the file type according to our needs. We will take this document in WPS Writer as an example here. It is also the same in WPS Presentation and WPS Spreadsheet.Select Document, then enter the keywords of the template we want to find in the search box to search.After finding the template we want, click Use Now to apply it to the document.To be office specialists, you could learn how to use WPS Office online in WPS Ac....

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