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.