How to use the SUM function

· Option 1:1. Select the cell range with data to sum up. 2. Click Formula → AutoSum You can also use the SUM function for multiple rows at the same time. · Option 2: 1. Choose the cell for sum up result.2. Input =SUM(B2:E2) .3. Press Enter on the keyboard.* If you want to get the rest of the results quickly, place the cursor at the down-right corner of F2 until symbol “+” present. Then, change the selected range with the mouse. To be office excel advanced, you could learn how to use W....

How to switch rows and columns in WPS Spreadsheet

How to switch rows and columns in WPS Spreadsheet1. First use mouse to select all table contents.2. Use the shortcut key CTRL+C to copy cell contents. 3. Click the sell where we want to put the table.4. Then right-click Paste Special → Transpose. Now the horizontal data is changed to vertical. Remember to select the original data and right-click to delete.This skill could also be used in Microsoft Office Excel and OpenOffice.

How to delete blank cells in WPS Spreadsheet

1. Open the table in WPS Spreadsheet.2. Click the Home tab → and then select the Find and Replace button.3. In the drop-down menu, click Go To. Then a Go To dialog box will pop up. We can also use its shortcut key Ctrl+G to open it.4. Check Blanks in the Go To dialog box, then click the Go To button in the upper right corner. 5. Now we have successfully selected all the blank cells. Right-click to select Delete in the drop-down menu. WPS Spreadsheet has provided us with different ways ....

How to add tick boxes in the table?

1. Open the table in WPS Office, and select the cell that you need to add a tick box.2. Click Insert → Symbol, and click the tick box symbol. For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.

Common shortcut keys in WPS Spreadsheet

New File Ctrl + NClose the window Ctrl + WOpen…Ctrl + OSave Ctrl + SPrint Ctrl + PUndo Ctrl + ZRedo Ctrl + YCopy Ctrl + CCut Ctrl + XPasteCtrl + VFindCtrl + FReplaceCtrl + HGo To…Ctrl + GSelection PaneCtrl + F1Go to the beginning of the cellCtrl + HomeGo to the end of the cellCtrl + EndCreate a new line within a cellAlt + EnterExpand selection to the beginning of the cellShift HomePopup menu (right-click menu)Shift + F10 Help center F1Start to edit the cellF2Spell check F7Recalculate w....

How to remove duplicates in Excel

· Highlight Duplicates1. Open the Excel file and select the table area.2. Click the Data tab → the Highlight Duplicates drop-down button → the Set option.3. Then, the Highlight Duplicate dialog will pop up. We click the OK button.4. Now, the repeated contents in cells are set in orange background. · Remove Duplicates1. Select the table area again.2. Go to the Data tab, click the Highlight Duplicates drop-down button, and select the Remove Duplicates option.3. Then, the Remove Duplicat....

How to insert and change the name of the slicers

Slicer is a very useful feature in WPS Spreadsheet. It can only be applied to a Pivot Table and can help users quickly filter various data. To learn more about the pivot table, you can watch some related videos in our WPS Academy.First, we need to create a Pivot Table.1. Open the table in WPS Spreadsheet, click the Insert tab → and click the PivotTable button, then the Create PivotTable interface will pop up.2. Select the cell range of the Pivot Table in the Select a range area.3. Sele....

How to do a Linear Regression in WPS Spreadsheet

Regression, in math, graphs the linear relationship between an independent and a dependent variable, trying to figure out how much one thing depends on another thing.For example, as light moves through a media, it will become dimmer as it is being extinguished. Absorbance is an expression of the amount of light absorbed by a solution. If we want to check whether there is a linear relationship between concentration and absorbance, how can we achieve it in WPS Spreadsheet? Use WPS Spread....