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.
Convert Word documents into PDF
· Option 1:1. Open the document to be converted. 2. Click the Tools tab → Export to PDF button · Option 2:1. Open the document in WPS Office. 2. Click the Menu tab → choose Export to PDF · Option 3:1. Open the Word document. 2. Get into the Menu tab → click Save as… → choose PDF Format (.pdf) in the File Type menu → SaveWPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt, and....
Clear and Avoid Duplicates Entries in WPS Spreadsheet
When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some two options to delete duplicates. · Option 1: 1. Select a range of cells. 2. Get into the Data tab → click the Highlight Duplicates dropdown button3. Pick the Set option from the drop-down list. Then, duplicated cells within the selected range will be highlighted.4. Right-click to select the fifth row → choose Delete in the popup menu· Option 2: 1. Se....
How can we delete single or multiple pages of PDF files?
WPS PDF offers two options to remove pages in PDF files. · Option 1: 1. Click the Page tab → Delete Pages 2. Choose Custom delete pages, and enter the page number to be deleted in the input box. 3. Then, click OK, and the selected pages in the opening PDF file will be deleted. (Tips: We can use “-” between two single-page numbers to delete consecutive pages. For example, if we want to remove the first three pages of the PDF file, enter “1-3” in the Custom delete pages input box.)· Op....