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....
How to change the page orientation of PDF
In WPS PDF, we can rotate an individual page or all pages of the whole PDF. · Rotate an individual pageTo change the orientation of a single page, use the mouse to select a page. Then, click the rotate clockwise or rotate counterclockwise icon in the Home Tab. Rotate an invividual page · Rotate all pages of PDFIf we want to change the orientation for all the pages, get into the Home tab, and click the Rotate button. Rotate all pages of PDFWith WPS PDF, you can read, take annotation, co....