To divide one column by another one, you can select the whole column and then enter the formula and use shortcut to quickly solve it. In situations when you want to prevent accidental deletion or alteration of a formula in individual cells, insert an array formula in an entire range.. For example, to divide the values in cells A2:A8 by the values in B2:B8 row-by-row, use this formula: =A2:A8/B2:B8 To insert the array formula correctly, perform these steps:

Select the number list you need to batch multiply, then click You can see the operation result as below screenshot shown.1. Place the mouse into the column that you want to place the result and select this whole column, and then enter the formula in Formula bar.

If you want to have a free trial ( 30-day) of this utility, Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

If there are two column data in a sheet, and you want to divide one column by the other one, except applying the formula =A1/B2 and dragging auto fill handle down until the end of data, is there any tricks to quickly divide one column by another one instead of manual dragging?To divide one column by another one, you can select the whole column and then enter the formula and use shortcut to quickly solve it.1.

Select the column with values you need to batch multiply or divide by a number, then click Then all selected cells are multiplied with a certain number at once. Suppose you want to divide each cell in a column of seven numbers by a number that is contained in another cell. In the cell C2, I type formula =A2/B2. Enter the certain number in a blank cell (for example, you need to multiply or divide all values by number 10, then enter number 10 into the blank cell). 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. Division operator can be used in excel by using the arithmetic operator slash (/) forward slash. How to divide one column by another with an array formula.

Press Enter.

Select the whole column that you want to divide, and click Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

1. Normally, you need to calculate them one by one with formulas.

See screenshot:If you want to divide a column values by a given value, supposing to divide column C by number 3, you can apply 1. In this article, we will show you two methods to quickly multiply or divide all values in a column by a number at once in details.You can multiply or divide all values in a column by a certain number as follows.1. The formula outputs 10 as 50 divided by 5 returns 10. Let's learn how to use formulas to divide numbers and calculate percentages in Excel. Enter the certain number in a blank cell (for example, you need to multiply or divide all values by number 10, then enter number 10 into the blank cell). In this example, the number you want to divide by is 3, contained in cell C2. Place the mouse into the column that you want to place the result and select this whole column, and then enter the formula in Formula bar.