How to Divide Without Using a Function in Excel (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

In Microsoft Excel using multiply, divide, and sum are the most common tasks to do. Microsoft Excel provides many simple ways to divide numbers and cells. You can use forward slash between cells, use QUOTIENT function to divide. Just apply the formula and then drag it down to get results in all the columns or rows. This article is about how to divide in excel without using a function.


How to Divide Without Using a Function in Excel: 2 Easy Steps

Follow my steps to divide in excel without using a function. By the end of these steps you will learn to divide in excel without using a function or formula.

Suppose we have a dataset of some sales amount of a shop. Each sale amount will be distributed among the shop’s 20 shareholders. Now we will divide all the sales amount with 20 to get the result.

Divide in Excel Without Formula


Step 1: Copy the Number and Go to Paste Special Command

  • Select the cell (E5) with which we will divide all the numbers from the list.
  • Press Ctrl+C to copy.

Copy the Number and Go to Paste Special Command

  • Now select cells to divide with the copied number. Here I have selected cells (C5) to (C14) to divide.
  • From the Home ribbon select “Paste Special” from the “Paste” option.
  • Follow this path: Home → Paste → Paste Special.

Read More: How to Divide for Entire Row in Excel


Step 2: Apply Divide Option to Divide Without Using Function

  • As we are dividing the whole column, we will select “All” to apply the method to all cells. Then we will select “Divide” from the new window.
  • Click OK to get the desired result.

Select Divide to Get the Result

  • Now we can see that we have got our precious result without using a formula.


Things to Remember

  • Division by zero is an operation for which there exists no result with values. When there is text in a selected cell or the cell is blank this error may show. #DIV/0! Error may also occur when the denominator in the division formula is equal to zero.
  • You can also go to the “Paste Special” command just by clicking the right button of the mouse after selecting the cells to divide.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

In this article, I have shown simple steps to divide in excel without using a function. Take a tour at the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. Stay tuned and keep learning.


Related Articles

Wasim Akram
Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo