Click on the cell containing a minuend a number from which another number is to be subtracted. Hold down Shift key. In our example you can use ctrl space because our formula is in the top row.
Then select the whole column by clicking on the alphabet on the top of the column.
Apply formula to the entire column In order to apply the formula to the entire column first you should select it. For making cell text uppercase please enter the formula UPPER B2 into the formula bar and then press the Enter key. Firstly enter the formula A1385 into the Cell C1 the first cell of column where you will enter the same formula secondly select the entire Column C and then click Home Fill Down. Select the entire column by clicking on the column letter Type to finish the formula and hit Enter In the example shown the formula in D2 is SUM BB.