Download WPS Office for your device

This lesson summarizes the printing problems commonly encountered in the workplace1. How to make the printer obedient, forms are printed on a sheet of paper2. How to select the designated printing area3. When the form file is very long, how to set each page has a title line4. how to set the header and footer, so that your document more professional

We often need use the Split Book function so that we can split a workbook into multiple files at work. Take this workbook as an example, which is a table of goods sales from January to September. Now we want to split it into three workbook files. 1. Head to the Home tab, click the Split Sheet drop-down button，and select Split Book.2. In the pop-up dialog, the current file is checked by default, and you can also split other files by clicking Add more files.3. When finished, click Next t....

By the end of the year, the Indonesian branch needs to make statistical analysis on the sales performance of the whole year. Now, we need to merge all the sales records from January to December into a worksheet, making the PivotTable function possible to use. What can we do? Go to the Data tab, click the Merge Sheet drop-down button, and click the merge multiple worksheets into a worksheet option. Click the Add File button in the pop-up dialog box, select the files from January to Dece....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, background images are nice-to-have if we are to beautify the table. Today, we will learn how to add a background picture and print it out. First, head to the Page Layout tab, click the Background button and select the desired images. Note: The inserted image, either too big or too small, is inappropriate. Here is a smart way for adjusting tho....

How can we insert or delete pages of the original file when editing a PDF file?Take this file as an example. Click the Page tab, then click the Insert Pages drop-down menu. Here, we can choose to insert a Blank page. Its shortcut key is Ctrl+Alt+I.In the popup dialog box, we can set the size, direction, number, and insertion position of the new page. Click OK to insert a blank page.We can also create a new page from the file by Select from PDF. Its shortcut key is Ctrl+Alt+T.After sel....

The system prints all the pages by default when printing a document. But what if we only want to print part of the pages in the document? Today we're going to share with you two solutions.l Method 1. Select the print range.Take this document as an example. If we only need to print pages 1, 4, 5, and 9, we can click the Print button in the upper left corner or press CTRL+ P to pop up the dialog box. At Page ranges, enter 1, 4, 5, 9, and insert commas to separate them from each other....