# How to Multiply Column by a Constant in Excel

To multiply a column by a constant in Excel, you can use a simple formula that multiplies the desired cell by the constant value. Here's how to do it:

- Open Excel and create a new worksheet or open an existing one containing the data you want to multiply.
- In an empty cell, type the constant value you want to multiply with the column values.
- Click on a new empty cell where you want the result to appear. This cell will be the starting point for the multiplied column.
- Type the formula
`=A1*$B$1`

, where A1 is the first cell of the column you want to multiply, and $B$1 is the absolute cell reference containing the constant value. You can change A1 and $B$1 to match your specific column and constant cell. - Press Enter to see the result of the multiplication in the selected cell.
- To apply the formula to the entire column, click on the cell with the result, and move your cursor to the bottom-right corner of the cell until you see a small cross icon.
- Click and drag the cross icon down the column to fill the formula for the rest of the cells.

## Example

Here's an example to help illustrate the process:

- Assume you have data in column A (from A1 to A5) and you want to multiply each value by a constant, say 3.
- In an empty cell, say B1, type the constant value 3.
- Click on cell C1 where you want the result of the first multiplication to appear.
- Type the formula
`=A1*$B$1`

in cell C1 and press Enter. - Now you should see the result of the multiplication (A1 * 3) in cell C1.
- Click on cell C1, move your cursor to the bottom-right corner of the cell until you see a small cross icon, then click and drag the cross icon down to C5 to fill the formula for the rest of the cells.
- Column C will now contain the multiplied values of column A by the constant 3.

Did you find this useful?