Home  >  Article  >  Topics  >  How to implement horizontal multiplication in excel?

How to implement horizontal multiplication in excel?

coldplay.xixi
coldplay.xixiOriginal
2020-06-20 16:44:3523899browse

How to implement horizontal multiplication in excel?

How to implement horizontal multiplication in excel?

Method to implement horizontal multiplication in excel:

1. Enter the multiplication formula "=A1*B1*C1*D1" in cell E1.

How to implement horizontal multiplication in excel?

2. Then enter the data to be multiplied in A1, B1, C1, and D1 in sequence, and the result will be displayed in "E1".

How to implement horizontal multiplication in excel?

#3. Use the mouse to select the "F1" cell. When the mouse turns into a black cross, hold down the left button and drag it down.

4. At this time, the formula in "F1" has been copied from F1 to the following F2, F3, F4, etc. Next time you need to perform calculations, enter the data directly in front. The results of the operation will be automatically displayed in F2, F3, F4 and other cells.

How to implement horizontal multiplication in excel?

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of How to implement horizontal multiplication in excel?. 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