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

Tips

Submit a Tip
All tip submissions are carefully reviewed before being published
Submit
Thanks for submitting a tip for review!

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' .

You Might Also Like

How to
Recover a Corrupt Excel File
How to Merge Cells in Microsoft Excel: A Quick Guide
Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
How to
Unprotect an Excel Sheet
How to Create a Graph in Excel
How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
How to
Create a Mortgage Calculator With Microsoft Excel
How to
Link Sheets in Excel
How to
Make a Spreadsheet in Excel
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
How to Unhide Multiple Rows in Microsoft Excel
How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
How to Combine Columns in Excel Without Losing Data
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 41,691 times.

Is this article up to date?

Advertisement