In our example you can use ctrl space because our formula is in the top row. Column Function in excel is one of the easiest function to be used which give returns the column number from the selected references. After entering the formula in cell F2 Press CtrlShiftEnd short keys.
Then select the whole column by clicking on the alphabet on the top of the column.
Hold the left click of the mouse drag the mouse down to the end of the page. To do this first start your SUM Function. Select the entire column and proceed to the other step. After entering the formula in cell F2 Press CtrlShiftEnd short keys.