How to Multiply Multiple Cells by One Cell in Excel?

You can multiply multiple cells by a single cell in Excel using a formula with absolute cell referencing. Here's how:

Using a Formula with Absolute Referencing

This is the most common and flexible method.

1. Identify the cell containing the number you want to multiply by (the "multiplier cell"). Let's say this cell is B1.
2. In the cell where you want the first result to appear, enter a formula like this: =A1*$B$1.
   • A1 represents the first cell you want to multiply.
   • $B$1 is the absolute reference to the multiplier cell. The dollar signs ($) before the column letter (B) and row number (1) ensure that this reference doesn't change when you copy the formula.
3. Press Enter. The cell will now display the result of A1 multiplied by the value in B1.
4. Copy the formula down or across to apply it to other cells. You can do this by:
   • Clicking and dragging the small square (fill handle) in the bottom-right corner of the cell with the formula.
   • Copying the cell (Ctrl+C) and pasting it into the desired range (Ctrl+V).

As you copy the formula, the A1 part will automatically adjust to the next cell in the column (e.g., A2, A3, A4), while the $B$1 part will always refer to cell B1.

Example:

	A (Value)	B (Multiplier)	C (Result)
1	2	5	=A1*$B$1 (Result: 10)
2	4		=A2*$B$1 (Result: 20)
3	6		=A3*$B$1 (Result: 30)

Using the PRODUCT Function (Less Common for This Specific Scenario)

While the PRODUCT function can multiply multiple numbers or cells, it's generally not the most efficient way to multiply a range of cells by a single cell. You would still need to use the absolute referencing method described above.

The PRODUCT function would look like this (and be much less efficient):

=PRODUCT(A1,$B$1)

And still require copying to other cells and using absolute referencing.

Summary

The easiest and most efficient way to multiply multiple cells by one cell in Excel is to use a simple multiplication formula (=A1*$B$1) with absolute referencing ($B$1) for the multiplier cell, then copy that formula to the desired range.