Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been viewed 54,900 times.
Learn more...
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
- Select the column where you want the results to appear.
- Type = into the formula bar.
- Type A1/B1 (if dividing column A by column B).
- Press Enter or Return.
- Drag the formula down the column.
Steps
Download Article
-
Open your project in Excel. 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. -
Select the column where you want to put the division results. 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 -
Type "=A1/B1" in the formula bar. 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.
-
Press Ctrl+↵ Enter (Windows) or ⌘ Cmd+⏎ Return (Mac). 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]
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'.
Video
Tips
References
- ↑ https://support.office.com/en-us/article/multiply-and-divide-numbers-in-excel-4585b0ea-0ea0-4faf-84e4-3db5d4b2dc5d
- ↑ https://www.extendoffice.com/documents/excel/4204-excel-divide-column-by-another-column.html#a1
- ↑ 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
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).
