Divide a range of cells by a number with Paste Special function For example I will divide all the cells by a number 15 using Paste Special function of Excel you can accomplish this task with the following steps. It involves two functions and an array formula. How to divide numbers in Excel To divide two numbers in Excel you type the equals sign in a cell then type the number to be divided followed by a forward slash followed by the number to divide by and press the Enter key to calculate the formula.
The forward-slash symbol.
The forward-slash symbol. Simply use the forward slash to divide numbers in Excel. Lets learn how to use formulas to divide numbers and calculate percentages in Excel. 155 3 In Excel we write a division expression like the above image where.