Home >Topics >excel >How to use formula from previous row in Excel table?

How to use formula from previous row in Excel table?

烟雨青岚
烟雨青岚Original
2020-06-12 15:20:1924853browse

How to use formula from previous row in Excel table?

The excel table follows the formula from the previous row:

1. First open the excel worksheet.

2. Secondly, select the cells in the previous row and set the relevant formulas.

3. Then move the mouse to the lower right corner of the cell until the mouse turns into a thick solid cross symbol.

4. Finally, drop down and fill in the formula to calculate the result using the formula in the previous row.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to use formula from previous row in Excel 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