Home >Topics >excel >How to pull down and automatically calculate the wps table

How to pull down and automatically calculate the wps table

尚
Original
2020-01-16 09:20:1619101browse

How to pull down and automatically calculate the wps table

WPS (full name Word Processing System), text editing system, is an office software produced by China Kingsoft Software Company. WPS is completely free for everyone to use, and all functions can be used by downloading.

Let’s take a look at how to pull down and automatically calculate in the WPS table:

1. Open the WPS table and enter relevant data.

How to pull down and automatically calculate the wps table

2. As shown in the figure, C1=A1*B1, enter "=" in the first cell under "C1".

How to pull down and automatically calculate the wps table

#3. Click the mouse to select the A1 data, then enter "*", and then click to select the B1 number.

How to pull down and automatically calculate the wps table

4. Press Enter. The results are as follows.

How to pull down and automatically calculate the wps table

#5. Place the mouse at the cell where the result is "39".

How to pull down and automatically calculate the wps table

6. When the mouse in the lower right corner changes to , pull the mouse down and the required result will appear.

How to pull down and automatically calculate the wps table

The above is the detailed content of How to pull down and automatically calculate the wps table. 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