Excel Division
Division Operator
In Excel, the / sign is used for division.
How to divide cells:
- Select a cell and type (=)
- Select a cell
- Type (/)
- Select another cell
- Hit enter
By putting a (/) in between the cells, you can add extra cells to the formula.
Let’s examine a few instances.
Dividing Manual Entries
First, let’s include a formula. Take a blank sheet and start.
Step by step:
- Type A1(=)
- Type 4/2
- Hit enter
Dividing Two Cells
Let’s expand our working set of numbers. Enter the values listed below:
Step by step:
- Type A3(=)
- Select A1
- Type (/)
- Select A2
- Hit enter
Dividing Using Absolute Reference
A cell can be divided and locked with other cells.
How to proceed, in detail:
- Select a cell and type (=)
- Select the dividend
- Type (/)
- Select the divisor lock and add two dollar signs ($) before the column and row
- Hit enter
- Fill the range
The number being divided by the divisor is known as the dividend.
Let’s see an example in which the fill function and absolute reference are used to divide B(5) by the range A1:A10.
Enter the values:
Step by step:
- Type C1(=)
- Select A1
- Type (/)
- Select B1 type dollar sign before column and row $B$1
- Hit enter
- Fill C1:C10
Fantastic work! You have successfully divided B1(5) using the range A1:A10 using absolute reference.
