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 insert a table in WPS Writer

After we use WPS Writer to open the document, first click the Insert tab, and then click the Table button. Here, we can find different ways to insert a table in WPS Writer. 1. We can directly select the row and column in the popup box, and then insert them into the document. 2. We can also insert a table by clicking Insert Table, then input the number of columns and rows according to our needs. Then click OK. 3. Or we can just click Draw Table and hold down the left mouse button to dra....

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 print a slide in WPS Presentation

First, use WPS Office to open the slide.Then click the Print button in the upper left corner or use the shortcut key Ctrl+P to use the print feature.In the Print pop-up box, we can adjust the settings according to our needs and then click OK. Note: We can click the Print Preview button on the upper left corner of the page to view the printout effect before printing.This skill could be compatible with Microsoft Office powerpoint.

How to set a picture as the background

After we use WPS Office to open the slide, click the Design tab, and then click the Background button. We can find the Insert the picture drop-down button in the popup window on the right side. Then select File. We can choose the picture according to our needs here, and click the OK button to apply the picture in the slide.This skill could be compatible with Microsoft Office powerpoint.

How to rename a worksheet

After we use WPS Office to open the spreadsheet, find the sheet tab below, and double-click the name of the worksheet.At this time, the name of the worksheet will be selected, and then we can directly enter the new name here.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to create a new slide in Presentation

After we use WPS Office to open the slide, select the place we want to insert a new slide. Then right-click. Find and click the new slide button. Now we have successfully added a blank new slide!This skill could be compatible with Microsoft Office powerpoint.

How to print a table in WPS Spreadsheet

1. First, use WPS Office to open the spreadsheet.2. Then click the Print button in the upper left corner or use the shortcut key Ctrl+P to use the print feature.3. In the Print pop-up box, we can adjust the settings according to our needs and then click OK.Note: We can click the Print Preview button on the upper left corner of the page to view the printout effect before printing.This skill could be also used in Microsoft Office Excel and Openoffice.