Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Google Sheets Division Operator


Division Operator

Division uses the / symbol in Google Sheets.

How to do division cells:

  1. Select a cell and type (=)
  2. Select a cell
  3. Type (/)
  4. Select another cell
  5. Hit enter

You can add more cells to the formula by typing (/) between the cells.

Let's have a look at some examples.


Dividing Manual Entries

Let's start with adding in a formula. Start with a clean sheet.

Step by step:

  1. Type A1(=)
  2. Type 4/2
  3. Hit enter


Dividing Two Cells

Let's add some numbers to work with. Type the following values:

Step by step:

  1. Type A3(=)
  2. Select A1
  3. Type (/)
  4. Select A2
  5. Hit enter



Dividing Using Absolute Reference

You can lock a cell and divide it with other cells.

How to do it, step by step:

  1. Select a cell and type (=)
  2. Select the dividend
  3. Type (/)
  4. Select the divisor lock and add two dollar signs ($) before the column and row or press F4
  5. Hit enter
  6. Fill the range

Note: Dividend is the number being divided by the divisor.

Let's have a look at an example where we divide B1(5) with the range A1:A10 using absolute reference and the fill function.

Copy the values to follow along:

Copy Values

Step by step:

  1. Type C1(=)

  1. Select A1

  1. Type (/)

  1. Select B1 type dollar sign before column and row $B$1

  1. Hit enter

  1. Fill C1:C10

Goob job! You have successfully used absolute reference to divide B1(5) with the range A1:A10.