Divide Multiple Excel Cells by the Same Cell
Question details
Divide values in one Excel column by a shared divisor and display the results in another column.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to divide each value in a column by the value in one fixed cell.
- Observed behavior
- Each result should use its own row's value while referring to the same divisor cell.
Check which column contains the values and which cell contains the divisor. In the example below, the values start in D2, the divisor is in F1, and results go in column G; make sure F1 contains a nonzero number.
Use an Absolute Reference for the Divisor in Excel
Use this formula to keep the divisor fixed while copying the calculation down a column.
Select cell G2, type =D2/$F$1, and press Enter. Replace the cell references if your values or divisor are elsewhere.
Select G2 and drag the fill handle at its lower-right corner down column G to the last row of values.
Select a result cell such as G3 and check the formula bar. The formula should read =D3/$F$1: the value reference changes, but the divisor remains fixed.

Divide a Column by One Cell in WPS Spreadsheet
Use the same absolute-reference formula in WPS Spreadsheet to divide a column of values by a fixed cell and fill the results down.
- 1. Open your spreadsheet: Open WPS Spreadsheet and select Open to choose your workbook.
- 2. Check the divisor: Select F1 and enter a nonzero divisor if it is not already there. This example assumes the values begin in D2.
- 3. Enter the formula: Select G2, enter =D2/$F$1, and press Enter.
- 4. Copy the calculation: Select G2 and drag its lower-right fill handle down to the last row of values.

Frequently Asked Questions
Why does the divisor change when I copy my formula down?
A reference such as F1 is relative, so it changes when copied. Use $F$1 in the formula, such as =D2/$F$1, to keep both the divisor's column and row fixed.
What does #DIV/0! mean in the result column?
The divisor is zero or blank. Select F1, or the divisor cell used in your formula, and enter a nonzero number.
Can I use a divisor in a different cell?
Yes. Replace $F$1 with an absolute reference to your divisor cell. For example, if the divisor is in B1, enter =D2/$B$1 in the first result cell.
Will changing the divisor update all the results?
Yes. When the formulas refer to $F$1, changing the value in F1 updates the results that use that cell.




