How to multiply a column by a fixed value in excel?

How to multiply a fixed value by a column in excel?

How to multiply a column by a fixed value in excel:

1. As shown below, if you want to set all the values ​​in column A to be multiplied by 1.13, then you can Enter 1.13 in a blank cell, then copy the cell, select column A, and click "Paste Options".

2. Click "Paste Special" in the pop-up drop-down menu.

3. Check "Value" in the paste box, check "Multiply" in the operation box, and click "OK".

4. At this time, you can multiply all the values ​​in column A by 1.13, and finally delete the 1.13 cell.

Recommended tutorial: "excel basic tutorial"

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