How to apply a formula to a column in Excel

Excel offers a very interesting way to apply a formula to a column. We can cater to this problem statement by using the CTRL & SPACEBAR keys. We can perform the below mentioned way to apply a formula to a column in excel:

We’ll learn about this methodology step by step.

To do this yourself, please follow the steps described below;

Step 1 – Excel workbook with a column with numbers

– Open the desired Excel workbook which contains a column populated with some numbers

Step 2 – Entering the formula

– Now in any cell type “=”, and then type “SUM(“. Now click on any cell in the column where the numbers are present. (We have selected cell “H2”)

Step 3 – Select the entire column

– Now click “CTRL + SPACEBAR”. This will select the entire column as shown in the image above. Now press “Enter”.

Step 4 – Sum obtained for entire column

– We can see the sum of the entire column now.