Home > Topics > excel > body text

How to multiply a column in Excel by the same number

藏色散人
Release: 2020-10-30 10:59:12
Original
13776 people have browsed it

How to multiply a column in Excel by the same number: First open the Excel file; then enter the formula [=A1*2.1] in cell B1; then place the mouse in the lower right corner of the cell and wait for the mouse mark to change A small black cross; finally press the left mouse button, drag down to cell B15, and release the left mouse button.

How to multiply a column in Excel by the same number

Recommended: "Excel Tutorial"

I will give you an example:

Change the cell The data in areas A1:A15 are multiplied by 2.1 at the same time, and then the corresponding product results are placed in cell areas B1:B15.

The effect is shown in the figure below.

How to multiply a column in Excel by the same number

First, enter the formula in cell B1:

=A1*2.1

Then press Enter, see the picture below

How to multiply a column in Excel by the same number

How to multiply a column in Excel by the same number

Place the mouse in the lower right corner of the cell, wait for the mouse mark to change to a small black cross, then press Press the left mouse button, drag down to cell B15, and release the left mouse button.

See the picture below

How to multiply a column in Excel by the same number

In this way, the data in cells B1:B15 is the result of multiplying the corresponding data in column A by 2.1

How to multiply a column in Excel by the same number

The above is the detailed content of How to multiply a column in Excel by the same number. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template