How To Divide Cells In Excel?

Select the cell or cells you want to divide

Enter the formula using the division operator `/`

Example: `=A1/B1`

Press `Enter`

Copy the formula to other cells if needed

Use absolute references with `$` if you want to keep one cell fixed

Example: `=A1/$B$1`

Use `Paste Special` if you want to divide existing values by a number

Enter the divisor in a cell

Copy that cell

Select the cells to divide

Click `Paste Special`

Choose `Divide`

Click `OK`

Suggested for You

Trending Today