How to Divide Every Cell in Excel by a Number: Steps

How-to basics · Updated November 20, 2026

To divide a range in place, enter the divisor in an empty cell, copy it, select the cells to change, then choose Home > Paste > Paste Special and select Divide. If you want to keep the original data, use a formula in a separate column instead. These methods work in Excel for Microsoft 365 on Windows; the guide below explains how to choose the right one and check the result.

Dividing every cell by one number is useful for rescaling values, converting units, or correcting a batch of entries—for example, turning cents into dollars by dividing by 100. Before you start, decide whether the original values should be replaced or retained. Make a copy of the worksheet or workbook if the data matters: Paste Special changes the selected cells, and that change cannot be reversed after you close the workbook.

What You’ll Need

  • An Excel worksheet containing the numbers you want to divide.
  • The divisor—the number each selected value will be divided by. It must not be zero.
  • An empty cell in which to enter the divisor for the Paste Special method.
  • A backup or duplicate of the data if you may need to restore the original values.

Step-by-Step

  1. Choose the cells to change. Identify the exact range that contains the numbers. For example, if the values are in B2:B20, select B2:B20—not the column heading in B1. If your data occupies a rectangular block, select the block. Avoid selecting the entire worksheet unless every cell really should be included.

    Check the selection for labels, totals, dates, and blank cells. Excel stores dates as numbers, so dividing a date can turn it into a different date rather than a useful measurement. If the range contains different kinds of content, select only the numeric cells that should be divided.

  2. Enter the divisor in an empty cell. Choose a cell outside the range you will change, such as F1, and type the number. For example, type 10 to divide each selected value by 10. Press Enter, then confirm that the cell shows the intended divisor and not a mistyped value. Do not use zero; division by zero is undefined and can produce errors.

  3. Copy the divisor cell. Select the cell containing the divisor and press Ctrl+C on Windows. The moving dashed border around the cell indicates that it has been copied. Copy the divisor itself, not the cells you plan to change.

  4. Open Paste Special for the destination range. Select the cells to divide. On Windows, press Ctrl+Alt+V to open the Paste Special dialog, or use Home > Clipboard > Paste > Paste Special. In Excel for Mac, select the destination range and use Edit > Paste Special; the available menu wording can vary slightly by Excel version.

  5. Choose the Divide operation. In the Paste Special dialog, find the Operation options and select Divide. Leave the other settings as they are unless you have a specific reason to change them. In particular, do not select a paste option that replaces the destination with the copied divisor. The operation should apply the copied number to the existing contents of the selected cells.

  6. Apply the operation and check the result. Click OK. Excel divides the selected numeric entries by the copied divisor. Confirm a few cells by doing the arithmetic yourself. If the original value was 120 and the divisor was 10, the result should be 12; 85 should become 8.5, and 40 should become 4. Also check that headings and cells outside the intended range did not change.

  7. Remove the temporary divisor when you are done. If the divisor cell is no longer needed, clear it after checking the result. You can also leave it in place and label it—for example, write Divisor next to it—if you want a record of the adjustment. Save the workbook once you are satisfied.

Alternative: use a formula to keep the source values. This approach is preferable when you want to review the results before replacing anything, or when you may later change the divisor. Suppose the original values are in A2:A20 and the divisor is in D1. With values in A2:A20 and the divisor in D1, enter this formula in B2:

=A2/$D$1

The dollar signs make D1 an absolute reference, so it remains the divisor when you fill the formula down. If A2 contains 120 and D1 contains 10, B2 returns 12. Copy B2 down through B20 using the fill handle or copy and paste. Check the results, then keep the formula column or copy it and use Paste Special > Values if you need fixed numbers. This leaves the source column intact until you choose to remove it.

Common Mistakes

  • Selecting too much. Selecting a whole column can affect headings, notes, totals, or unrelated numbers. Select the specific data range and inspect its boundaries before applying the operation.

  • Using the wrong operation. Paste Special includes Add, Subtract, Multiply, and Divide. If Multiply is selected by mistake, the values will increase rather than decrease. Check that Divide is selected in the dialog before clicking OK.

  • Copying the wrong cell. The operation uses the copied cell as the divisor. If you copied a blank cell, a text label, or the wrong number, the results will not be what you intended. Confirm the copied source and divisor before applying the change.

  • Dividing identifiers or dates. Account numbers, product codes, postal codes, and dates may look numeric but usually are not quantities to scale. Dividing them can damage their meaning or display. Exclude them from the selection.

  • Overwriting formulas without meaning to. If the selected range contains formulas, Paste Special can alter those cells as well as ordinary numbers. Keep a backup and inspect formula cells first. If you need to preserve the original formulas, calculate the divided results in a new column instead.

  • Forgetting display formatting. A cell may hold a correct decimal result but display no decimal places, making it appear rounded. The underlying value may still be precise. Adjust the number format if the visible result needs more detail.

Tips

  • Use Paste Special for a one-time change. It is quick when you are certain the existing values should be replaced and the selection contains only appropriate data.

  • Use formulas when the divisor may change. A formula linked to a divisor cell recalculates when that cell changes. This is easier to audit than manually repeating the calculation, and it keeps the source values available for comparison.

  • Keep a clear divisor label. If the adjustment needs to be understood later, put a label beside the divisor or add a short note explaining why the data was divided. This is especially useful in shared workbooks.

  • Check number formats after dividing. If the results are measurements, decide how many decimal places are useful. Select the result cells and use Home > Number to choose a suitable format or adjust the decimal places. Formatting changes what you see, not the stored calculation.

  • Test on a small copy first. For a large or important dataset, copy a few representative cells to a spare area and try the operation there. Include a decimal, a whole number, and any unusual values you expect in the real selection.

  • Keep an audit trail when needed. A separate formula column, a duplicate sheet, or a saved copy gives you a way to compare before and after values. This is more reliable than depending on Undo as your only recovery plan.

Troubleshooting

The cells did not change. Confirm that the divisor cell was copied before you selected the destination cells, and that the destination range was highlighted when you opened Paste Special. Reopen the dialog and make sure Divide is selected. If you used a formula instead, check that you entered it in the intended cell and filled it through the full range.

The values became larger. The Multiply operation may have been selected, or the copied cell may not contain the divisor you intended. Use Undo immediately if available, then repeat the steps and verify both the source cell and the Divide option. If Undo is no longer available, restore the backup rather than trying to estimate the original values.

You see an error or an unexpected result. Check that the divisor is a nonzero number and that the destination cells contain numeric values. Text entries may not behave like numbers, and a formula in the source range may produce an error of its own. For formula-based results, check that the divisor reference points to the correct cell and that the divisor cell is not blank or zero.

The answer looks rounded. Select a result cell and look at the formula bar to see its stored value. If the formula bar shows more digits than the cell, change the display using Home > Number and increase the displayed decimal places. Do not round the values unless that is part of the intended calculation.

Some cells changed and others did not. Check whether the skipped cells contain text, are outside the selected range, or were excluded because the range was selected incorrectly. For a non-contiguous selection, hold Ctrl while selecting additional ranges on Windows, but take care to include only cells that should be changed. On Mac, use Command while selecting separate ranges.

Frequently Asked Questions

Can I divide an entire column in Excel?
Select the used numeric cells in the column and apply Paste Special > Divide. Avoid selecting the header or unrelated entries. You can select the whole column only if every cell in it is appropriate to change.

Does Paste Special Divide keep the original numbers?
No. It changes the selected cells in place. Make a copy first, or use a formula in another column if you want the originals to remain available.

Can I divide cells by a decimal, such as 2.5?
Yes. Enter 2.5 in the divisor cell and use the same Divide operation. Check a sample result to confirm the decimal was entered as intended for your regional number settings.

How do I divide without changing the source data?
Put the divisor in a cell and enter a formula in a new column that divides the source cell by the divisor cell. Fill the formula down, then review the results before deciding whether to keep them as formulas or copy them as values.

Will this work in Excel for the web?
Excel for the web supports many Paste Special options, but the dialog and available operations can differ from desktop Excel. If you do not see a Divide operation, use a formula in a new column or open the workbook in Excel for Microsoft 365 on Windows or Mac.

Can I undo the operation?
Usually you can press Ctrl+Z on Windows immediately after applying it, or Command+Z on Mac. Undo may no longer be available after closing the workbook or making other changes, so save a backup before changing important data.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.