First enter the formula in the first cell of the column in which you want to apply the formula. The easiest way to apply a formula to the entire column in all adjacent cells is by double-clicking the fill handle by selecting the formula cell. However Excel also has a different kind of cell range that omits the row number and pulls in all of the cells in the entire column.
You need to drag towards the right to apply the formula to the entire row.
Suppose you have the dataset as shown below where want to calculate the commission for each sales rep in Column C where the commission would be 15 of the sale value in column B. Now select the entire column-This applies even for the Row. For example you are supposed to apply the formula of A1385 to the entire column B. For example if you want to find the sum of all of the values in column C you would type SUM CC.