This article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 40,248 times.
Learn more...
This How.com.vn 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
- 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]
Tips
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'.
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).
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.