How to Divide a Column by a Number in Excel – 3 Methods

This is the sample dataset.


Method 1 – Divide a Column by a Number Using a Formula

To divide the revenue by the price per unit:

Steps:

  • Enter the following formula in the first cell of the column:

=D5/100

The formula divides the revenue in D5 by 100, the price per unit.  ” / “ is used for division in Excel.

How to Divide a Column by a Number in Excel

  • Copy the cell by pressing CTRL + C.

How to Divide a Column by a Number in Excel

  • Paste it into the rest of the cells in the column by pressing CTRL + V.

Divide a Column by a Number Using a Formula

  • You can also Copy and Paste by double-clicking on the right-down corner of the cell or dragging down the the Fill Handle.

Read More: How to Divide One Column by Another in Excel


Method 2 – Dividing a Column by a Number with the Paste Special Method

Steps:

  • Copy the cell containing the number by which the column will be divided.

How to Divide a Column by a Number in Excel

  • To open the Paste Special option, select all cells in the column and press CTRL + ALT + V.

Divide a Column by a Number with Paste Special Method

  • You can also open the Paste Special option by right-clicking after selecting all cells in the column.
  • Select Paste Special.

Divide a Column by a Number with Paste Special Method

  • In ‘Paste Special’, select Divide in Operation.
  • Click OK.

Divide a Column by a Number with Paste Special Method

This is the output.

Read More: Division Formula in Excel for Multiple Cells


Method 3 – Divide a Column by a Number Using Cell References

Steps:

  • Enter the divisor into a cell. Here, C3 is the divisor.
  • Use this formula in the first cell of the column:
=D5/$C$3

Use $ to make the divisor an absolute cell reference.

Divide a Column by Using Cell References

  • Copy the formula and paste it into the other cells by using CTRL + C and CTRL + V.

Divide a Column by Using Cell References


The #DIV/0! Error

If you input the divisor value as zero, a #DIV/0! Error will be displayed.

Read More: [Fixed] Division Formula Not Working in Excel


Download Practice Workbook

Download the practice workbook here:


Related Articles


<< Go Back to Divide in Excel | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Osman Goni Ridwan
Osman Goni Ridwan

OSMAN GONI RIDWAN is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, OSMAN has transitioned into the role of a content developer. Specializing in creating technical content exclusively centered around Excel... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo