Divide a Cell by a Number in Excel: Formula Guide

Formulas & functions · Updated November 20, 2026

To divide a cell by a number in Excel, enter a formula such as =A2/5 in an empty cell, replacing A2 with the cell you want to divide and 5 with your divisor. Press Enter to calculate the result, then fill the formula down if you need to divide more values. You can also put the divisor in its own cell and reference it, which makes it easy to change the number later.

What You’ll Need

  • An Excel workbook with the values you want to divide. This guide uses Microsoft Excel for Microsoft 365 on Windows; the formulas also work in current Excel for Mac and Excel for the web.
  • An empty column or range for the results if you want to keep the original values unchanged.
  • The number you want to divide by. You can type it into the formula or store it in a separate cell.

Before starting, check that the cells contain numbers rather than text that only looks like numbers. If the source data matters, keep the original column and calculate results in a separate one. This makes it easier to review the calculation and correct a mistake without re-entering your data.

Step-by-Step

  1. Identify the value and divisor. Decide which cell contains the value to be divided and which number will be the divisor. For example, if A2 contains 250 and you want to divide it by 5, the calculation should return 50. The cell reference goes before the division operator, and the divisor goes after it. Excel uses the forward slash / for division.
  2. Choose where the answer should appear. Click an empty cell next to the source value, such as B2. Using a separate result cell preserves the original value in A2. If there is a header row, put a clear label such as “Divided by 5” in B1 so you can tell what the calculated column represents.
  3. Enter the formula and calculate it. With the value in A2 and the result going in B2, type =A2/5 in B2 and press Enter. The equals sign tells Excel to calculate a formula; A2 identifies the input; and 5 is the divisor. If A2 contains 250, Excel displays 50 in B2. If your workbook uses a different source cell or divisor, substitute those for A2 and 5.
  4. Apply the same division to more rows. If the values are in A2:A11, and B2 contains =A2/5, select B2 and move the pointer to the small square at its lower-right corner, called the fill handle. Drag it down to B11. Excel adjusts the relative reference as it fills: B3 uses A3, B4 uses A4, and so on. You can also copy B2, select B3:B11, and paste. Check the last few rows to confirm that each result refers to the value on its own row.
  5. Use a cell for the divisor if you may change it. Enter the divisor 5 in E1, for example, then use a reference to E1 in the formula. With the values in A2:A11, the divisor in E1, and the result starting in B2, enter =A2/$E$1 in B2. If A2 is 250 and E1 is 5, the result is 50. The dollar signs make E1 an absolute reference, so it stays fixed as you fill the formula down. Change E1 to a different number and Excel recalculates the results.
  6. Check the result and the formula. Click a result cell and look at the formula bar to verify the cell reference and divisor. Check one calculation manually: 250 divided by 5 is 50. If you see too many decimal places, select the result cells and use Home > Number to choose a number format or adjust the decimal-place buttons. Formatting changes how a result appears; it does not change the underlying calculation.

On a Mac, enter and fill the formula the same way; the slash and dollar-sign references are identical. Keyboard shortcuts for copying and pasting differ: Windows uses Ctrl+C and Ctrl+V, while Mac uses Command+C and Command+V. In Excel for the web, formulas and the fill handle work in the browser as well. If the fill handle is inconvenient, copy the formula cell and paste it into the destination cells.

Optional: Divide the original values in place

If you need to replace the source numbers rather than keep separate results, Excel desktop has a Paste Special operation. First make a backup or copy the source data somewhere safe: this method changes the selected values, and the change may not be easy to restore after further edits. Enter the divisor in an unused cell and copy that cell. Select the original numbers, then choose Home > Paste > Paste Special. In the dialog, select Divide under Operation and choose OK. Excel divides each selected value by the copied number. Confirm that the selected range contains only the intended numeric cells before applying the operation. The Paste Special operation is available in desktop Excel; options may differ in Excel for the web.

Common Mistakes

  • Using the wrong operator. Excel division uses a forward slash, as in =A2/5. A backslash or a multiplication sign will not perform the intended calculation.
  • Forgetting the equals sign. Without = at the start, Excel may treat the entry as text instead of calculating it. If the formula appears literally in the cell, check the equals sign and the cell’s number format.
  • Letting the divisor reference move. A formula such as =A2/E1 changes E1 to E2 when filled down. If every row must use the same divisor, use =A2/$E$1 so the reference remains fixed.
  • Dividing by zero or a blank divisor cell. A divisor of zero produces #DIV/0!. A blank cell used as a divisor is also treated as zero for this calculation. Confirm the divisor cell contains the intended nonzero number.
  • Overwriting source data by accident. Typing a formula into the same cell as the original value replaces that value. Put the formula in a separate column unless you deliberately want to replace the original data using a method such as Paste Special.
  • Assuming displayed rounding is the actual result. A cell formatted to show two decimal places may display 3.33 even when the stored result has more digits. Use the formula bar or increase the displayed decimal places when checking precision.

Tips

  • Label both inputs and outputs. A header like “Original amount” and another like “Amount divided by 5” helps make the worksheet understandable later. If the divisor is in a separate cell, label that cell too.
  • Use one divisor cell for repeat calculations. A reference such as =A2/$E$1 makes it simple to test another divisor: change E1 once instead of editing every formula. Keep the divisor cell visible and clearly identified.
  • Fill a formula down efficiently. If the source data is in a continuous column, double-click the fill handle in B2 to extend the formula alongside adjacent data. Inspect the filled range afterward, especially if there are blank rows or neighboring columns with different lengths.
  • Keep full precision when it matters. Number formatting can show fewer decimals without changing the stored result. Avoid rounding the formula itself unless you specifically need a rounded value for a later calculation. If a particular number of decimal places is required, decide whether that is a display preference or a calculation requirement.
  • Consider a Table for expanding data. If you regularly add rows, convert the data range into an Excel Table with Insert > Table. A formula entered in a table column generally fills down that calculated column and extends to new rows, reducing manual copying.
  • Use Paste Special only when replacing values is intentional. Formula-based results are easier to audit and update. The in-place operation is useful for a one-time adjustment, but it removes the original values from the selected cells, so preserve a copy first.

Troubleshooting

The cell shows #DIV/0!. Check the divisor in the formula or the divisor cell. It must not be zero or blank. If the divisor is in E1, click E1 and verify that it contains a number; also check that the formula points to E1 rather than a blank cell. Do not hide the error until you know why it occurred.

The formula is visible instead of the result. Make sure the entry starts with =. If it does, the cell may be formatted as Text, or there may be an apostrophe before the equals sign. Change the cell format to General using Home > Number Format, then edit the formula and press Enter again. Changing the format alone may not recalculate text already entered as a formula.

The result is wrong after filling down. Click a few result cells and compare their formulas. If the divisor reference shifted, edit the first formula to use an absolute reference, such as =A2/$E$1, and fill it down again. If the source reference is wrong, correct the first formula so it points to the matching row before copying it.

Excel does not recognize a value as a number. A value imported from another file may be stored as text, sometimes because of leading spaces, an apostrophe, or an unexpected decimal separator. Try selecting the source cells and choosing the warning icon’s Convert to Number option when Excel offers it. You can also inspect a cell in the formula bar and remove unwanted spaces or characters. Regional settings can affect whether decimals use a period or a comma, so enter the divisor in the format Excel expects.

The answer displays as a date, percentage, or unexpected number of decimals. The result cell may have inherited formatting from another cell. Select the results and choose an appropriate format under Home > Number, such as General or Number. This changes the display, not the division formula. If the displayed value still seems wrong, inspect the formula and the underlying source values rather than relying only on the formatted appearance.

Frequently Asked Questions

What symbol do I use to divide in Excel?

Use the forward slash, /. For example, if the value is in A2 and you want to divide by 5, enter =A2/5 in another cell. Excel calculates the result when you press Enter.

How do I divide an entire column by the same number?

Enter a formula beside the first value, then fill it down. For values in A2:A11 divided by 5, put =A2/5 in B2 and fill through B11. If the divisor is stored in E1, use =A2/$E$1 instead so the reference to the divisor does not move.

Can I divide by a number stored in another cell?

Yes. Refer to that cell after the slash. For example, with the value in A2 and divisor in E1, enter =A2/E1. If you will copy the formula down and need every row to use E1, lock the reference as =A2/$E$1.

How do I divide without changing the original value?

Put the formula in a different cell or column. For instance, calculate from A2 in B2 with =A2/5. The original value remains in A2, while B2 shows the result. This is the safest approach when you may need to revise or verify the calculation.

Can I divide several selected cells in place?

In desktop Excel, copy a cell containing the divisor, select the values to change, then use Home > Paste > Paste Special and choose Divide under Operation. This replaces the selected numbers, so make a copy of the data first. Excel for the web may not offer the same Paste Special operation.

Why does my division result have many decimal places?

Excel keeps the calculated precision even if the cell displays fewer digits. Select the result cells and use the number-format controls on Home to increase or decrease the displayed decimal places. Change the formula only if you intentionally need the calculated value itself rounded.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.