This article was written by Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. 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 9,874 times.
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.
Steps
-
1Open 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.
-
2Select 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
-
3Type "=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.
-
4Press Ctrl+↵ Enter (Windows) or ⌘ Cmd+⏎ Return (Mac). This applies the formula to the entire selected column so the selected column will divide A by B.[2]Advertisement
References
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).
