Formula Errors

Divide Multiple Excel Cells by the Same Cell

Steve KSteve K Nov 20, 2026 868 views

Question details

Divide values in one Excel column by a shared divisor and display the results in another column.

How to Divide Multiple Excel Cells by the Same Cell
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.
Before you start

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.

Solution 1Recommended

Use an Absolute Reference for the Divisor in Excel

Use this formula to keep the divisor fixed while copying the calculation down a column.

1
Enter the formula

Select cell G2, type =D2/$F$1, and press Enter. Replace the cell references if your values or divisor are elsewhere.

2
Fill the formula down

Select G2 and drag the fill handle at its lower-right corner down column G to the last row of values.

3
Check a copied formula

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.

Use an Absolute Reference for the Divisor in Excel
Why the dollar signs matter: The dollar signs in $F$1 lock both the column and row. If F1 is blank or zero, Excel returns a #DIV/0! error.
Calculate with WPS Spreadsheet

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. 1. Open your spreadsheet: Open WPS Spreadsheet and select Open to choose your workbook.
  2. 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. 3. Enter the formula: Select G2, enter =D2/$F$1, and press Enter.
  4. 4. Copy the calculation: Select G2 and drag its lower-right fill handle down to the last row of values.
Keep a shared divisor fixed with an absolute cell referenceOpen and save Microsoft Excel .xlsx and .xls filesFill formulas down a column using the fill handleUse familiar spreadsheet tools in a free office suite
microsoft office alternative - wps office

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.