How do you divide in Excel 2021?

Redeem nowYou can divide in Excel using a few different methods.It's easy to divide two numbers or cell values in Excel using the forward slash in a simple formula.You can also di

How do you divide in Excel 2021?

Redeem now

  • You can divide in Excel using a few different methods.
  • It's easy to divide two numbers or cell values in Excel using the forward slash in a simple formula.
  • You can also divide a column of values by a constant, using the dollar sign to create an absolute reference in your spreadsheet.
  • Visit Business Insider's homepage for more stories.

There are a few common techniques for performing division in Excel.

You can divide numbers directly in a single cell, or use a simple formula to divide the contents of two different cells. You can also set up a formula that divides a series of values by a constant.

Here's what you need to know to divide in Excel on a Mac or PC.

Check out the products mentioned in this article:

MacBook Pro (From $1,299.99 at Best Buy)

Lenovo IdeaPad 130 (From $299.99 at Best Buy)

How to divide two numbers in Excel

You can divide two numbers using the forward slash (/) in a formula.

If you type "=10/5" in a cell and press Enter on the keyboard, you should see the cell display "2."

You can also divide the values stored in different cells.

1. In a cell, type "=".

2. Click in the cell that contains the dividend (the dividend is the number on the top of a division calculation).

3. Type "/".

4. Click the second cell that contains the divisor.

5. Press Enter.

You can divide the contents of cells in a simple division formula.Dave Johnson/Business Insider

How to divide a column of values by a constant

It's not uncommon to need to divide a column of numbers by a constant. You can do that by using an absolute reference to the cell that contains the constant divisor.

1. Create a column of numbers that will serve as the dividend in your division calculations. Then put the constant divisor in another cell.

2. In a new cell, type "=" and click the first cell in your list of dividends.

3. Type the name of the cell that contains the divisor, adding a "$" before both the letter and number. Using the dollar sign in this way turns the reference into an absolute reference, so it won't change when you paste it elsewhere in the spreadsheet.

You can use an absolute reference to a cell to divide a bunch of numbers by constant divisor.Dave Johnson/Business Insider

4. Press Enter.

5. Copy and paste this result to other cells to do more division on the other dividends. You can drag the cell by its lower right corner to copy it down a column.

When you drag the formula down a column, you can perform the first division formula on a slew of additional numbers.Dave Johnson/Business Insider

How to merge and unmerge cells in Microsoft Excel in 4 ways, to clean up your data and formatting

How to lock cells in Microsoft Excel, so people you send spreadsheets to can't change certain cells or data

How to alphabetize data in an Excel spreadsheet by column or row, and by using shortcuts

How to embed a YouTube video into a PowerPoint presentation, depending on the version of your PowerPointDave JohnsonFreelance WriterDave Johnson is a technology journalist who writes about consumer tech and how the industry is transforming the speculative world of science fiction into modern-day real life. Dave grew up in New Jersey before entering the Air Force to operate satellites, teach space operations, and do space launch planning. He then spent eight years as a content lead on the Windows team at Microsoft. As a photographer, Dave has photographed wolves in their natural environment; he's also a scuba instructor and co-host of several podcasts. Dave is the author of more than two dozen books and has contributed to many sites and publications including CNET, Forbes, PC World, How To Geek, and Insider.Read more Read less

Insider Inc. receives a commission when you buy through our links.

Video liên quan