• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Divide in Excel

March 4, 2021 by Andrew Childress
Cells divide in Excel

Need to divide two numbers? This easy step by step guide will teach you how to quickly divide in Microsoft Excel.

Need to divide two numbers? Let’s learn how to quickly divide in Microsoft Excel.

When you’re doing division in Excel, you’ll likely encounter one of two scenarios. One happens when you want to type in two numbers and divide them in a single cell. The other is when you have existing numbers already in cells, and want to divide those.

Divide in Excel (In a Single Cell)

Let’s say you need to divide 40 by 8. To get started, click into any cell in your workbook. Begin by typing an = sign. (Tip: This is how you start every formula in Excel).

Then, type 40, followed by /, and then 8.

Divide in Excel

Your formula will look like this: =40/8

Press Enter on your keyboard, and boom, Excel returns your solution in the cell: 5.

Divide in Excel (With Existing Numbers)

Suppose you have two numbers listed on your cell, as you can see here. You may want to divide these, and since they’re already typed in, there’s no reason to input them again.

Find an empty cell, and click to select it. Once again, type =. But this time, click the first cell: the number that you want to divide (also called the dividend).

Cells divide in Excel

 

Then, type /, and click on the other cell, which is your divisor. When you’re finished, hit Enter and you’ll see the result appear in the cell.

Divide in Excel results

How to Copy Division Formulas in Excel

Now, suppose you have several data sets like you can see here. You might want to divide each one to compare the results. Thanks to Excel’s ability to drag formulas, you can do these calculations in seconds.

Click into the first solution cell, then hover your cursor over the lower right corner. You’ll see the (+) symbol appear. Then, click and drag downward.

Excel will automatically insert the formula, adapting it for the adjacent data. It’s that easy. You only have to type the formula once, then let Excel do the work!

Divide in Excel autofill

As you can see, Microsoft Excel offers several great ways to divide numbers. These tricks save you valuable time and help you get what you need from your data.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Formulas show formulas ExcelShow Formulas in Excel
Next Post:Not Equal To In Exceltwo lists data not equal to in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top