There are 8 free training classes of how to use office suite for Get Started
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 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 italicize the selected contents
Take WPS Writer as an example.First, select the contents that need to be italicized.Then click the Home tab, and then click the Italic bottom. By this, we can easily italicize the selected contents.We can also use the shortcut key Ctrl+I to italicize. To be office specialists, you could learn how to use WPS Office online in WPS Academy.
How to Align Text Vertically in WPS Office [Easy Way]
This is a tutorial on how to align text vertically in WPS Office 2023. Learn how to easily change the alignment of text with WPS Office
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 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....
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 quickly number rows in WPS Spreadsheet
After we open the spreadsheet in WPS, enter 1 in the first cell you want to number. Place the mouse cursor on the lower right corner of the next cell. When we see that the mouse cursor turns into a plus icon, just click and hold to drag down the cursor to automatically number rows according to our needs.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.