Sometimes, we apply a formula in a cell and then repeat the same formula to the entire column in **Microsoft Excel**. But repeating the same formula again and again for every cell can be a hectic and time-consuming task. When you have a large dataset, sometimes it becomes quite impossible to repeat the formula manually. Are you having trouble repeating the formula for the whole column in Excel? This tutorial will help you to learn **how to repeat formula in Excel for whole column 5 easy ways**. Let’s get started!

## Download Practice Workbook

You can download the** Excel workbook** from here.

## 5 Easy Ways to Repeat Formula in Excel for Whole Column

In order to repeat the formula for the whole column in Excel, we have taken a dataset like the following figure where we have **the names **of **6** students and their marks in **Math** and **English**. We will add one student’s marks using **Excel** formula and then repeat the formula for the whole column using **Fill Handle**, **Fill Down** **option**, **Keyboard Shortcut**, **Copy Pasting** **method,** and **Entering formula to multiple cells method**.

### 1. Use of Fill Handle

Now we will repeat the formula for the whole column in **Excel** using the **Fill Handle**. This is the most common and easiest method in this respect. In order to use this method, follow the steps below.

**Steps:**

- First, select cell
**E5**and type the following formula:

`=C5+D5`

- Now, press
**Enter**. - As a result, you will see an output like the image below which it will display the total marks of
**John**.

- Second, select cell
**E5**and drag the**Fill Handle**to the entire column**Total Marks**. - Finally, you will see an output like the below one where it will display all students’ total marks.

**Note:**We can also do this operation by

**double-clicking**the

**Fill Handle**instead of

**dragging**it to the entire column.

**Read More:** **How to Repeat Number Pattern in Excel (5 Methods)**

### 2. Using Fill Down Option

We can also use the **Fill Down** option to repeat the formula for the whole column in **Excel**. This is also an easy and efficient way to do the job. In order to use this method, follow the steps below.

**Steps:**

- First, select cell
**E5**and type the following formula:

`=C5+D5`

- Second, press
**Enter**. - As a result, you will see an output like the image below which will display the total marks of
**John**.

- After that, select all the cells of column
**Total Marks**including cell**E5**. - Furthermore, go to the
**Home**tab.

- Next, click on the
**Fill**drop-down and select the**Down**option.

- As a result, you will see an output like the below one where it will display all students’ total marks.

**Read More:** **How to Repeat Formula Pattern in Excel (Easiest 8 ways)**

### 3. Use of Keyboard Shortcut

We can use the **Keyboard Shortcut** method to repeat the formula for the whole column in **Excel**. If you are someone who likes to use keyboard shortcuts instead of mouse, this method can be helpful for you. In order to apply this method, follow the steps below.

**Steps:**

- First, select cell
**E5**and type the following formula:

`=C5+D5`

- Second, press
**Enter**. - As a result, you will see an output like the image below which will display the total marks of
**John**.

- After that, select all the cells of column
**Total Marks**including cell**E5**.

- Subsequently, press
**Ctrl+D**. - Hence, you will see an output like the below one which will display all students’ total marks.

**Read More:** **How to Find Repeated Numbers in Excel (5 Easy Methods)**

**Similar Readings**

**How to Repeat Multiple Rows in Excel (4 Effective Ways)****How to Repeat Rows at Top in Excel (3 Suitable Ways)****[Fixed!] Excel Rows to Repeat at Top Feature Greyed Out****How to Repeat Header Row When Scrolling in Excel (6 Ways)****How to Repeat Rows in Excel at Bottom (5 Easy Ways)**

### 4. Applying Copy Pasting Method

The **Copy Pasting** method is another way to repeat the formula for the whole column in **Excel**. This is also a user-friendly way to perform the task. In order to apply this method, follow the steps below.

**Steps:**

- First, select cell
**E5**and type the following formula:

`=C5+D5`

- Second, press
**Enter**. - As a result, you will see an output like the image below which will display the total marks of
**John**.

- After that, copy the cell
**E5**by pressing**Ctrl+C**as shown below.

- Furthermore, select the cells of the column except for cell
**E5**where you want to apply this formula like the below one.

- Hence, paste the formula by pressing
**Ctrl**+**V**and you will see an output like the one below where it will display all students’ total marks.

**Read More:** **How to Repeat Rows in Excel Based on Cell Value (4 Easy Ways)**

### 5. Entering Formula to Multiple Cells

**Entering formulas into multiple cells** is another option to repeat formulas for the whole column in **Excel**. This is also an easy way to perform this task. In order to apply this method, follow the steps below.

**Steps:**

- To begin with, select all the cells of the column
**Total Marks**and type the following formula in one of the cells as shown below:

`=C5+D5`

- Secondly, press
**Ctrl**+**Enter**. - Hence, you will see an output like the below one which will display all students’ total marks.

**Read More:** **How to Repeat Cell Values in Excel (6 Quick Methods)**

## Things to Remember

- Using
**Fill Handle**is the most common and easiest way to repeat formulas for the whole column in Excel. - If you have a very large dataset, then the
**Keyboard Shortcut**method will be the most convenient method. - You can also apply the Fill
**Down****option**,**Copy Pasting****method,**or**Entering formula method**for small datasets.

## Conclusion

Hence, follow the above-described methods. Thus, you can easily learn **how to repeat formula in Excel for whole column**. Hope this will be helpful. Follow the **ExcelDemy **website for more articles like this. Don’t forget to drop your comments, suggestions, or queries in the comment section below.

**Related Articles**

**Repeat Rows a Specified Number of Times in Excel (4 Easy Ways)****How to Repeat Rows in Excel When Printing (3 Effective Ways)****[Fixed!] Excel Rows to Repeat at Top Not Working (4 Solutions)****How to Repeat Cell Value X Times in Excel (6 Easy Methods)****Repeat Formula in Every nth Row in Excel (2 Easy Ways)****How to Repeat Rows at Top of Specific Pages in Excel**