To copy formulas in Excel is one of the easiest works. Microsoft Excel offers many ways to do the same work and in this article, weâ€™ll get to learn seven suitable ways how we can **copy formula **to entire column in Excel effectively with appropriate illustrations.

**Table of Contents**hide

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

**7 Suitable Ways to Copy Formula To Entire Column in Excel**

Letâ€™s say, we have a dataset where different types of **Fruits** and their **price** in **January** are given in **Column B**, and **Column C** respectively. We need to find the rate of increase of these items. To do this we will use one specific formula and copy the same formula to the entire column. Hereâ€™s an overview of the dataset of our todayâ€™s task.

**1. Use of the Fill Command to Copy Formula To Entire Column**

Let, the price of **Apple** is **$1391.00** that has been given in **cell C5**. Now, we want to calculate the **10% increased** price of **Apple** in **Column D**. To determine the increasing price of** Apple** and other fruits, weâ€™ll use the **Fill Command**. Letâ€™s follow the instructions.

**Step 1:**

- First, select
**cell D5**.

- Now, type the formula in
**Formula Bar**. The formula is,

`=C5*10%`

- After typing the formula in the
**Formula Bar**, press**Enter**on your keyboard and you will get the increasing price of**Apple**in**cell D5**and the increasing price is**$139.10**.

**Step 2:**

- Now select
**cell C5**to**cell C14**.

- From your
**Home Tab**, go to,

**Home â†’ Editing â†’ Fill â†’ Down**

- After following the above instruction, you will get the increasing price of the other fruits.

**2. Apply the Autofill Handle to Copy Formula in Excel**

In this method, weâ€™ll learn how to copy the formula to the entire column by using the **Autofill Handle**. Letâ€™s follow the steps.

**Steps:**

- In
**cell D5**, type the formula,

`=C5*10%`

- After typing the formula in the
**Formula Bar**, press**Ente**r on your keyboard and youâ€™ll get the return of the formula in**cell D5**. The return value of the formula is**$131.10.**

- Now, place the
**cursor**on the**Bottom-right**in**cell D5,**and a**Plus-sign(+)**pops up. Then**Double-Click**on your**Left-Button**on the**Plus sign(+)**and instantly youâ€™ll get your desired result.

**3. Using the Keyboard Shortcuts to Copy Formula To Entire Column**

Here, weâ€™ll learn how to **copy formulas in Excel to the entire column by using keyboard shortcuts.** For this, follow these steps.

**Step 1:**

- First of all, select
**cell D5**and type the formula in the**Formula bar**. The formula is,

**
**

`=C5*10%`

- Now, press
**Enter**on your keyboard and you will get the increasing price of**Apple**. The increasing price of**Apple**is**$139.10**.

**Step 2:**

- After that, select
**cell D5**to**cell D14**and press**Ctrl+D**on your keyboard.

- Then, press
**Enter**on your keyboard and youâ€™ll get your desired output in**Column D**.

**4. Insert an Array formula to Copy Formula To Entire Column**

Letâ€™s say, we are applying the Array formula in our dataset to copy the formula to the entire column. Letâ€™s follow these steps to learn!

**Steps:**

- First, select
**cell D5**and type the formula in the**Formula Bar**. The formula is,

`=C5:C14*20%`

- Now, press
**Enter**on your keyboard and youâ€™ll get your desired output in**Column D**which is given in the screenshot.

**Similar Readings:Â **

**How to Copy Excel Sheet with Formulas to Another Workbook (5 Ways)****Copy Formula in Excel by Changing Only One Cell Reference**

**5. Use the Copy-Paste Method to Copy Formula To Entire Column**

In this method, we are using the **Copy-Paste** method to copy formulas in** Excel** to the entire column. We want to calculate the increasing **20% price** of the fruits that have been given in **Column C5**. This method is discussed below.

**Step 1:**

- In
**cell D5**, type the formula. The formula is,

`=C5*20%`

- After typing the formula in the
**Formula Bar**, press**Enter**and youâ€™ll get the return of the formula is**$278.20**in**cell D5**.

**Step 2:**

- Now, select
**cell D5**and press**Ctrl+C**on your keyboard. - After that, choose the entire column from
**cell D5**to**cell D14.**

- Finally, press
**Ctrl+V**on your keyboard and you get your desired output that has been given in the screenshot.

**6. Apply the Ctrl+Enter Method to Copy Formula To Entire Column**

In our dataset, the price of fruits for **January** is given in **Column C**. Let the fruit price be increased by **30%** for next month. Now, weâ€™ll calculate the increasing price of the fruits by using **Ctrl + Enter** Command on our keyboard to copy the formula to the entire Column. Follow the steps below to learn!

**Steps:**

- First, select
**cell D5**to**cell D14.**

- Now, type a formula in the
**Formula Bar**. The formula in the**Formula Bar**is,

`=C5*30%`

- After typing the formula in the
**Formula Bar**, press the**Ctrl+Enter**buttons on your keyboard**simultaneously**. Then youâ€™ll get your desired result in**Column D**.

**7. Create A Table to Copy Formula Automatically in Excel**

After learning the above Methods, here weâ€™ll learn to copy formulas automatically to the entire column by creating a table. For this, follow the steps below.

**Steps:**

- First, select the range where we want to create the table.

- After selecting the range, press
**Ctrl+T**on your keyboard, and a**Create Table**box pops up. Press**OK**to continue.

- After that, select any blank cell on the selected table where weâ€™ll apply our formula. Letâ€™s say, in
**cell D9**, we want to apply the formula. In that cell, type the formula that has been given below.

`=[@[January]]*30%`

- After completing the above steps, now press
**Enter**on your keyboard and youâ€™ll get your desired output that has been given in the screenshot.

**Things to Remember**

đź‘‰ To copy formulas in excel to the entire column, we are applying keyboard shortcuts like **Ctrl+C** and **Ctrl+V.**

đź‘‰ Another way is to copy formula in excel to the entire column,**Home **â†’** Editing **â†’** Fill **â†’** Down**

đź‘‰ we can also use **Ctrl+D** to copy the formula to the entire column.

**Conclusion**

Today, we learned how to copy formula in excel to entire column. I hope all of the suitable methods mentioned above to copy formulas to the entire Column will now provoke you to apply them in your **Excel** spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.