Download WPS Office for your device

When copying formulas to other cells, we might encounter three reference modes, namely relative reference, absolute reference, and mixed reference. We need to choose the proper reference method according to the specific calculation requirements and the formula. · 1. Relative ReferenceWhen copying formulas to other cells, the formula will change according to the position of the referenced cell.Take this table as an example. Enter =B2*C2 in cell D2, and then pull down the fill handle to ....

When printing WPS Spreadsheet, in order to print out the table more readable and more beautiful, we can set up the printed page of the table. Take this table as an example. First, click the Page Layout tab and then click the Print Titles button to enter the Page Setup dialog box. If we want to print a specific part of the area, select the area that needs to be printed in the Print area box. If we want to print too much data, we can print them on several pages. Except for the first pag....

We can insert shapes into a worksheet with WPS Spreadsheet. For example, we can insert shapes as background into the four cells. This operation will emphasize the content in the corresponding cells. How can we realize it? Get into the Insert tab, and click the Shapes dropdown button. Then choose a shape that you want in the dropdown menu. In this example. we choose the Rounded Rectangle button. As you can see, the cursor turns into a cross + symbol. We can use it to draw a shape where....

Creating forms is an essential skill for our daily work. Mastering the form skills can make our work more effective. Now starting from the basic interface, we will explain what a form worksheet and workbook is.First, we click Spreadsheets on the New page, then click Blank to create a new blank file at the bottom. Now enter the main interface of the table. Above the table is the functional area, which is often used when we edit the table. We will also introduce the usage of these featur....

The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

Do you know how to lock cells in WPS Spreadsheet so that they cannot be modified by others? Take this table as an example. 1. Click the Review tab. 2. When finding that the Lock Cell button is gray, it means that the entire table is now locked. At this point, click Protect Sheet. 3. Check the Select Locked cells and Select Unlocked Cells options in the pop-up dialog box. 4. Enter a password and click OK to confirm. Then we will find that the form cannot be edited.What needs to be aware....

In WPS Spreadsheet, there are many ways to merge worksheets. Do you know how to merge worksheets of the same name correctly?Take this workbook as an example, and you can find three worksheets that record students' scores in mathematics, physics, and chemistry respectively.Teachers need to extract the scores of mathematics, physics, and chemistry from these three classes and then put the scores of each subject in different workbooks. What can we do? First, click the Data tab, click ....

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. While processing a table, we have to double-click a cell containing a function formula to view the referenced data cell, However, this will easily lead to incorrect editing of the formula. At this time, we can use the function of Tracking Precedents of WPS table.Take this table as an example. We want to see which cells are referenced by the formula of ....