Divide by Half in Excel: Formulas and Steps

Formulas & functions · Updated November 20, 2026

To divide a value by one half in Excel, use a formula such as =A2/0.5; this doubles the value because dividing by 0.5 is the same as multiplying by 2. If you mean to make a value half as large, divide it by 2 instead, using =A2/2. The distinction matters: the phrase “divide by half” is often used when someone actually means “halve it.”

The steps below use Excel for Microsoft 365 on Windows. They show how to calculate results in a new column, fill the formula down, and—if necessary—divide existing values in place. The formulas leave the source data intact unless you deliberately replace it or use Paste Special.

What You’ll Need

  • An Excel workbook with the numbers you want to change or calculate. For the examples, the original values are in column A, starting at A2.
  • A blank column for formula results if you want to preserve the original values.
  • A clear decision about the intended operation: divide by 0.5 to double a value, or divide by 2 to halve it.
  • If changing values in place, make a copy of the workbook or data first so you can recover the originals.

Step-by-Step

  1. Check what “divide by half” means in your task. In ordinary arithmetic, dividing by one half makes a number twice as large. For example, 12 divided by 0.5 is 24: there are two halves of 12 in 24. By contrast, dividing 12 by 2 gives 6, which is half of 12. Confirm which result you need before entering a formula. This is especially important when editing a shared worksheet, where a colleague may use “divide in half” to mean reduce values by 50%.
  2. Choose a result column and enter the correct formula. Suppose the original values are in A2:A20 and you want to show each value divided by 0.5 in column B. Click B2 and enter =A2/0.5, then press Enter. If A2 contains 12, the result in B2 is 24. The formula refers to the value in A2, so you can reuse it for the other rows. If instead you want to halve each value, use =A2/2; with A2 equal to 12, the result is 6. Keep the original column unchanged until you have checked that the results are right.
  3. Use a cell for the divisor if you may need to change it. Enter 0.5 in D1, then refer to that cell in your calculation. With original values in A2:A20 and 0.5 in D1, enter =A2/$D$1 in B2. If A2 is 12, B2 returns 24. The dollar signs make the D1 reference absolute, so it stays fixed when the formula is copied down. For halving, you could put 2 in D1 instead; the same formula would return 6 for an original value of 12. Label D1 clearly, for example, “Divisor,” so its purpose is apparent later.
  4. Copy the formula through the rows you need. Select B2 and point to the small square at the lower-right corner of the selection, called the fill handle. Drag it down through the rows with source values. Excel adjusts the relative reference in each row: the formula in B3 will use A3, the one in B4 will use A4, and so on. If the source column has a continuous block of data next to the result column, you can double-click the fill handle; check the last filled row, since Excel uses adjacent data to decide how far to copy. You can also select the formula cell and the cells below it, then choose Home > Fill > Down. On Mac, the ribbon command is also available; keyboard shortcuts can vary with keyboard layout and Excel settings.
  5. Check several results and the displayed number format. Compare the first, a middle, and the last result against a quick hand calculation. For example, if the source values are 12, 7, and 0, dividing by 0.5 should produce 24, 14, and 0. Dividing those values by 2 should instead produce 6, 3.5, and 0. A cell can display fewer decimal places than its stored value, so select a result and look at the formula bar if the screen appears to show a rounded number. Adjust the displayed decimals with the decimal-place buttons on Home if you need to inspect the precision.
  6. Replace the original values only if that is what you intend. The formula method is safer because it keeps the source data. If you want the final numbers in the original column, first confirm the results, copy the calculated cells, then use Paste Special to paste values over the originals. In Excel for Microsoft 365 on Windows, select the destination, choose Home > Paste > Paste Special, select Values, and click OK. This removes the formulas from the pasted cells. Keep a backup if you may need the initial values later.

If you need to divide existing values by 0.5 directly rather than create a formula column, Excel desktop also has Paste Special’s Divide operation. Enter 0.5 in an unused cell and copy it. Select only the numeric cells to change, open Home > Paste > Paste Special, choose Divide under Operation, and click OK. Each selected value is divided by 0.5, so it doubles; a selected value of 12 becomes 24. This operation overwrites the selected numbers, so save a copy first and avoid selecting headers, labels, or unrelated cells. For halving values in place, copy 2 and choose Divide instead. Paste Special options can differ in Excel for the web; use a formula column there if the Divide operation is not available in your interface.

Common Mistakes

  • Using the wrong meaning of “half.” =A2/0.5 doubles the source value; it does not halve it. To reduce a value to half, divide by 2. Look at the expected direction of change: dividing a positive number by 0.5 should make it larger, while dividing by 2 should make it smaller.
  • Typing a decimal comma or an incomplete expression. In a formula, type =A2/0.5 using the decimal separator recognized by your Excel regional settings. Excel may display or expect a comma as the decimal separator in some locales, so follow the format used by your installation if it rejects the dot. Do not omit the equals sign: without it, Excel may treat the entry as text rather than calculate it.
  • Copying a formula that points to the wrong row. When entering a formula in B2, make sure it refers to A2, not a different row or a fixed source cell. When a divisor is stored in D1, use an absolute reference such as $D$1 so it does not move as you fill down. Check the formula bar in a few rows to verify that the references follow the intended pattern.
  • Overwriting the source too soon. A formula column and an in-place operation are not the same. A formula in B2 leaves A2 unchanged; Paste Special with Divide changes the selected cells themselves. Keep the original data until you have compared the output and confirmed whether the workbook needs formulas, values, or both.
  • Mistaking formatting for a calculation error. A result may look unchanged if the cell is formatted to display zero decimal places, or it may show rounded decimals that hide precision. Formatting changes how a value appears, not the calculation stored in the cell. Inspect the formula bar or increase displayed decimal places before diagnosing an incorrect result.

Tips

  • Label the operation in the worksheet. Add a heading such as “Value divided by 0.5 (doubled)” or “Value halved (divided by 2).” This prevents someone reading the sheet later from interpreting the operation differently.
  • Use the divisor cell for reusable calculations. A separate input cell makes it easy to switch from one divisor to another without editing every formula. Use an absolute reference to keep the divisor fixed when filling down, and consider adding a note beside it explaining the intended calculation.
  • Preserve the original values when the calculation may be reviewed. Keeping source values in one column and results in another makes it easier to audit, compare, or correct a calculation. Once verified, copy and paste values only if a fixed result is needed and formulas are no longer required.
  • Account for blank cells and non-numeric entries. A formula referring to a blank cell generally calculates as zero, while text in a referenced cell can cause a value error. If your column includes notes or blank rows, inspect the results and adjust which rows you fill rather than assuming every cell contains a number.
  • Use clear number formatting for fractional results. Dividing by 2 can produce values such as 3.5, and other source numbers may produce more decimal places. Choose a number format that shows enough precision for your purpose. Do not round values merely to make the sheet look neater unless rounding is part of the requirement.

Troubleshooting

The result is twice the number, but I wanted half. The formula divided by 0.5, which doubles a number. Replace the divisor with 2. With source data in A2:A20 and a formula in B2, enter =A2/2 to halve the value in each corresponding row. For example, an A2 value of 12 returns 6. Fill the corrected formula down again, or update the divisor input cell if you used one.

Excel shows the formula instead of a result. Confirm the entry starts with an equals sign and that the cell is not formatted as Text. Change the cell format to General using Home > Number Format, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. Also check whether Show Formulas is enabled: press Ctrl+` on Windows to toggle it. The grave accent key is usually near the top-left of the keyboard. On Mac, use Control+` where that shortcut is available, or turn off Show Formulas from the Formulas tab.

The formula returns #DIV/0!. This error means the divisor is zero or refers to a cell containing zero. If you use a divisor cell, check that it contains 0.5 for doubling or 2 for halving, not 0. Also ensure the formula points to the intended divisor cell and that the cell was not accidentally cleared.

The result is #VALUE! or an unexpected zero. Check whether the source cell contains text that looks like a number, an error, or an unexpected blank. Select the source and inspect its contents in the formula bar. Convert numeric text to numbers if appropriate, and confirm that the formula uses the correct row reference. If the cell is genuinely blank, decide whether a zero result is acceptable or whether that row should remain blank.

Paste Special changed the wrong cells. Immediately use Ctrl+Z on Windows, or Command+Z on Mac, if the change is still undoable. If you have already made other changes or closed the workbook, restore a saved copy or use version history if available. For future edits, select only the intended numeric range, avoid entire columns unless necessary, and test the operation on a small copied range first.

Frequently Asked Questions

Does dividing by half make a number smaller? No. Dividing by 0.5 makes a number twice as large. For example, 8 divided by 0.5 is 16. To make 8 half as large, divide it by 2, which gives 4.

What formula halves a value in Excel? With the original value in A2, enter =A2/2 in another cell. If A2 contains 15, the result is 7.5. Fill the formula down to apply the same calculation to more rows.

Can I divide a whole column without writing a formula for every row? Yes. Enter the formula in the first result cell and use the fill handle to copy it down. For example, with source values in A2:A100, enter =A2/0.5 in B2, then fill down through B100. The resulting values are twice their corresponding source values. Check the final row to ensure the formula filled to the intended extent.

Can I change the original numbers instead of making a second column? Yes. Excel desktop’s Paste Special Divide operation can change selected values in place. Copy a cell containing 0.5, select the numbers, then choose Home > Paste > Paste Special > Divide. The selected numbers will double. Make a copy first, because the operation overwrites the original values. A formula column is preferable when you need to retain the inputs or review the calculation.

Why does dividing by 2 sometimes show a whole number? The underlying result may include decimals that the cell format hides. Select the result and increase the displayed decimal places from Home, or inspect the value in the formula bar. For example, 7 divided by 2 is 3.5; if the cell shows 4, it may be formatted with zero decimal places rather than containing a different calculation.

Do the same formulas work in Excel for Mac and Excel for the web? The basic division formulas, such as =A2/0.5 and =A2/2, work in current Excel for Microsoft 365 on Windows, Mac, and the web. Ribbon placement and keyboard shortcuts may differ between platforms. If Paste Special’s Divide operation is missing in the web version, calculate in a separate column and paste values instead.

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.