How to quickly adjust the cell size

After using WPS Office to open the spreadsheet, just drag the dividing line between rows and columns to quickly adjust the cell size.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet 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 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.

How to insert a line break inside a cell in WPS Spreadsheet

1. Use WPS Office to open the spreadsheet first. 2. Select the cell where we want to insert a line break in, then place the mouse cursor where we start a new line, and double-click.3. Now click the Home tab, and click the Wrap Text button.Then we can see that a line break has been successfully added in the cell. We can also use the shortcut key Alt+Enter to start a new line.This skill could be also used in Microsoft Office Excel and Openoffice.

How to insert a chart in WPS Spreadsheet

1. Open the spreadsheet and select the data that needs to be used in the chart.2. Then click the Insert tab, and then click the Chart button.3. In the Insert Chart popup box, select the type and style of the chart according to our needs.(For example, we are going to select Column → Clustered Column here.)4. Then double-click the button of Clustered Column.Now we have successfully inserted the chart in WPS Spreadsheet!This skill could be also used in Microsoft Office Excel and Openoffic....

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 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 insert page numbers in a document

1. First, use WPS Writer to open the document and then click the Page Number button in the Insert tab. Then we can easily insert page numbers in the document.2. After we click the Page Number button, we will automatically jump to the interface of the Header and Footer tab, therefore just click the Close button to quit the edit interface. This skill could also be used in Microsoft Office Word and Openoffice.