How to Divide Numbers in Excel. We know how to divide, by paper. Or, we can just try to solve the problem using the calculator. Now, can you divide in Excel? Well, multiplication is the opposite of division, and it does not mean you enter. Follow the steps given in this video to perform division in Microsoft® Excel 2007 on your Windows® based PC. Content in this video is provided on an as is . How to Divide in Excel. Microsoft Excel is a spreadsheet program that allows you to organize and store data. One of its main functions is the use of mathematical formulas that divide, multiply, add and subtract numbers according to your. How to Divide in Excel Using a Formula Division formulas, DIV/O! formula errors, and calculating percentages. by. Ted French. Writer. Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. our editorial process. Ted French. How to Divide in Excel: It’s Easier Than You Think. Brittani Sponaugle. Share this article. Creating an Excel spreadsheet can be a formidable task if you’re not too familiar with excel formulas. Dividing in Excel is easiest when you use a formula. An example of how to divide in Excel, using cell references, is shown in cell A1 of the above spreadsheet on the right. This division formula divides the value in cell B1 (the number 15) by the value in cell B2 (the number 4). Again, the formula returns the value 3.75. Division Error How to Use Divide Formula in Excel? Division operator can be used in excel by using the arithmetic operator slash (/) forward slash. For example, click on the cell A2 with the mouse pointer and enter = sign and type the division sign (/) forward slash as =B2/C2 and press the enter key, where b is the dividend and c is the divisor which will give you the desired output. How to divide in Excel. If you’re looking to learn how to divide in Excel, you’ll need to know how to write Excel formulas. Excel formulas are expressions used to display values that are calculated from the data you’ve entered and they’re generally used to perform various mathematical, statistical, and logical operations. 7a. First, divide the value in cell A1 by the value in cell B1. 7b. Next, select cell C1, click on the lower right corner of cell C1 and drag it down to cell C6. Take a look at the screenshot below. To divide a column of numbers by a constant number, execute the following steps. 8a. First, divide the value in cell A1 by the value in cell A8.