How to Divide Two Columns in Excel: Easy Step-by-Step Tutorial

PDF download Download Article
Learn how to divide two columns in Excel in a few easy steps
PDF download Download Article

This wikiHow will show you how to divide one column by another column in Microsoft Excel for Windows or macOS. In Excel, the forward-slash (/) acts as a division symbol, making it easy to divide cells with a simple formula.

Quick Guide: Dividing Columns in Excel

  1. Select the column where you want the results to appear.
  2. Type = into the formula bar.
  3. Type A1/B1 (if dividing column A by column B).
  4. Press Enter or Return .
  5. Drag the formula down the column.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ac\/Divide-Two-Columns-in-Excel-Step-1.jpg\/v4-460px-Divide-Two-Columns-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/a\/ac\/Divide-Two-Columns-in-Excel-Step-1.jpg\/v4-728px-Divide-Two-Columns-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can either open your project within Excel by navigating to File > Open or by right-clicking the file in Finder and selecting Open With > Excel .
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e3\/Divide-Two-Columns-in-Excel-Step-2-Version-2.jpg\/v4-460px-Divide-Two-Columns-in-Excel-Step-2-Version-2.jpg","bigUrl":"\/images\/thumb\/e\/e3\/Divide-Two-Columns-in-Excel-Step-2-Version-2.jpg\/v4-728px-Divide-Two-Columns-in-Excel-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    For example, if you want to divide column A by column B, you might select column C. Click the letter above a column to select all of its cells.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/Divide-Two-Columns-in-Excel-Step-3-Version-2.jpg\/v4-460px-Divide-Two-Columns-in-Excel-Step-3-Version-2.jpg","bigUrl":"\/images\/thumb\/e\/e1\/Divide-Two-Columns-in-Excel-Step-3-Version-2.jpg\/v4-728px-Divide-Two-Columns-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Replace "A1" and "B1" with the actual cell locations you want to divide. For example, if you want to divide column A by column B and the first values appear in row 1, you'd use A1 and B1. Although you're entering specific cells now, you'll be applying the formula to the whole column in a moment. [1]
    • The formula bar is right above the sheet.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Divide-Two-Columns-in-Excel-Step-4.jpg\/v4-460px-Divide-Two-Columns-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/f\/f9\/Divide-Two-Columns-in-Excel-Step-4.jpg\/v4-728px-Divide-Two-Columns-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This divides the first cell by the second cell. To apply the calculation to the entire column, just drag the bottom-right corner of the quotient down the column to divide all cells in the columns. [2]
    5. Advertisement

Common Questions

How do I divide an Excel column into two?

Select the column you want to split, select Data > Text to Columns , choose Delimited > Next , and select your delimiters. Click Next , choose a destination, and click Finish . [3]

How do I divide in Excel?

To divide one cell by another, use the formula =(cellA)/(cellB). Replace cellA with the dividend (e.g., A1), and cellB with the address of the divisor (e.g., B1).

How do you divide a cell by a number?

If you want to divide the value of cell A2 by 100, you'd use the formula =A2/100' .

Tips

Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Submit
Thanks for submitting a tip for review!

You Might Also Like

How to
Unprotect an Excel Sheet
How to
Merge Cells in Microsoft Excel: A Quick Guide
How to
Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
How to
Create a Graph in Excel
How to
Show Hidden Columns in Microsoft Excel & Unhide Column A
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Create a Mortgage Calculator With Microsoft Excel
How to
Unhide Multiple Rows in Microsoft Excel
3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
How to
Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
How to
Change from Lowercase to Uppercase in Microsoft Excel
How to
Add a Column or Calculated Field in an Excel Pivot Table
The Best Ways to Make & Format Lists in Excel
How to
Add a Best Fit Line in Excel
Advertisement

References

  1. ↑ https://support.office.com/en-us/article/multiply-and-divide-numbers-in-excel-4585b0ea-0ea0-4faf-84e4-3db5d4b2dc5d
  2. ↑ https://www.extendoffice.com/documents/excel/4204-excel-divide-column-by-another-column.html#a1
  3. ↑ https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7

About This Article

Article Summary X

1. Open your project in Excel.
2. Select the column where you want to put your division results.
3. Enter " =A1/B1 " in the formula bar.
4. Press Ctrl + Enter (Windows) or Cmd + Return (Mac).

Did this summary help you?
Thanks to all authors for creating a page that has been read 48,690 times.

Is this article up to date?

Advertisement