There are 8 free training tips of how to use office suite for WPS
Free Word templates specially for you in WPS Office
The use of Word document is not limited to pure writing. Posts, resumes, schedules and the like can also be designed and created in a word document. To make a word page with a sense of design, you can download free Word templates in WPS Office. · Steps to download free Word templates in WPS Office.1. Open WPS Office.2. Head to the homepage > Apps > Templates to enter the template library. 3. Click Document on the left to view the templates for word.4. Click the theme on the top to view....
Free download a must-have PDF reader for PC | WPS PDF
If you are searching for a handy and powerful PDF Reader, then you’ve come to the right place! WPS Office provides you with a user-friendly PDF reader for free download. Follow the steps to get the PDF reader right now. · Why should you choose WPS PDF Reader?WPS PDF Reader is a module of WPS Office, which is the best alternative to Microsoft Office. WPS Office integrates all office processor functions such as Word, PDF, Presentation, Spreadsheet, in one application. It's available ....
Set Header/Footer at Page Setup in excel
Are you still not a confident WPS Spreadsheet user and see page set up as a tricky matter? Don't worry. To help out, we've prepared this tutorial just for you. Page Setup consists of four parts, namely, Page, Margins, Head/Footer and Sheet. In today's tutorial, we will learn the Head/Footer.· Example of setting Head/Footer in Page SetupGo to the Page Layout tab, and click Settings > Page setup. Head to the Header/Footer tab, where you can set the header and footer with so....
How to compare two excel sheets and highlight differences
In this article, you will know how to quickly compare two excel sheets and highlight differences with only 6 simple steps as follows. How to quickly compare two excel sheets for differences in values? You can use the View Side-by-Side comparison function if your boss requires you to immediately find out the differences between the two Excel sheets.For example, this is book1 and this is book2, click on View Side-by-Side and you can manually find out the differences in their values row b....
The COUNTA function in excel
In WPS Spreadsheet, the COUNTA function can help us count the amount of cells left non-empty. · The COUNTA function:=COUNTA(value1, [value2], ...) · Use the COUNTA function for total attendance:In the following example, we use the COUNTA function to calculate total attendance. 1. Enter the formula =COUNTA(C5:C11)2. Press Enter to get the result. As we can see, since 4 cells in total are filled with '√', the result is '4', with the empty cells skipped.Use the COUNTA func....
How to set print area in a worksheet
1. Open the worksheet (XLS. Or XLSX. files) in WPS Spreadsheets. 2. Select the cell area to be printed → click the Page Layout tab → Print Area dropdown button → choose Set Print Area from the drop down list.3. Then, click Print Preview to preview effect. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to duplicate a sheet in WPS Spreadsheet
· Option 1:1. Use WPS Office to open the sheet.2. Click the title area of the sheet below, right-click and select Duplicate Sheet. · Option 2:1. Use WPS Office to open the sheet.2. While pressing the Ctrl key, click the left mouse button to drag the sheet to the desired position. Then, we can complete the copy of the sheet. · Option 3:1. Use WPS Office to open the sheet.2. Click the title area of the sheet below, right-click and select Move Sheet.3. In the pop-up dialog, choose Move t....
How to edit a hyperlink
Take this document in WPS Writer as an example. It is also the same in WPS Presentation and WPS Spreadsheet.1. Open the file in WPS Office.2. Now find the hyperlink we want to edit, then right-click to select Edit Hyperlink in the popup drop-down menu. 3. Now a Edit Hyperlink dialog box will pop up. Here, we can adjust different types of hyperlink.4. Take Existing File or Web Page as an example.We can adjust the text of the hyperlink in the Text to display input box below. We also can ....