Home >Common Problem >How to automatically add, subtract and sum in WPS tables?

How to automatically add, subtract and sum in WPS tables?

coldplay.xixi
coldplay.xixiOriginal
2020-06-18 11:22:4618827browse

How to automatically add, subtract and sum in WPS tables?

How to automatically add, subtract and sum in wps tables?

How to automatically add, subtract and sum in wps table:

1. Open wps table, click the new button on the main interface of wps table to create a New execl to complete automatic summation. As shown below.

How to automatically add, subtract and sum in WPS tables?

#2. After opening the wps form, enter the data to be automatically summed. We use the mouse to select the row of data to be summed. Remember to leave a space after the selected data. As shown below.

How to automatically add, subtract and sum in WPS tables?

3. After selecting the numbers for automatic summation, we find the "Automatic Sum" button on the toolbar. We click on the wps table to automatically sum. The result is as shown below.

How to automatically add, subtract and sum in WPS tables?

#4. After clicking the wps automatic sum button, the blank grid of the selected row will be automatically summed and displayed, as shown in the figure below.

How to automatically add, subtract and sum in WPS tables?

5.

How to automatically add, subtract and sum in WPS tables?

6. We can also automatically sum multiple rows at one time. At this time, we only need to use the mouse to select multiple lines. Note that there should be a blank space after each selected line, and then click wps to automatically sum, as shown in the figure below.

How to automatically add, subtract and sum in WPS tables?

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to automatically add, subtract and sum in WPS tables?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn