# How to Copy Formula to Entire Column in Excel (7 Ways)

Letâ€™s say there’s a dataset where different types of Fruits and their prices in January are given in Column BÂ and Column C, respectively. You need to find the rate of increase of these items. To do this, you will use one specific formula and copy the same formula to the entire column. Here’s an overview of the dataset for today’s task.

### Method 1 â€“Using the Fill Command to Copy the Formula to an Entire Column

Let’s say the price of Apple is \$1,391, as shown in cell C5. The task is to calculate the 10% increasing price of Apple in Column D. To determine the increasing price of Apple and other fruits, youâ€™ll use the Fill Command.

Step 1:

• Select cell D5.

• Enter the following formula in the Formula Bar:
`=C5*10%`

• Press Enter to get the increasing price of Apple in cell D5. As you can see below, the increasing price is \$139.10.

Step 2:

• Select cell C5 to cell C14.

• Click on your Home Tab, followed by the Editing option. Then, follow the steps pictured below:

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

• You will get the increasing price of the other fruits.

Read More: How to Copy Exact Formula in Excel

### Method 2 â€“ Applying the Autofill Handle to Copy the Formula to the Entire Column

Steps:

• In cell D5, enter the following formula:
`=C5*10%`

• Press Enter to get the return of the formula in cell D5. The return value of the formula is \$131.10.

• Place the cursor in the bottom-right corner of cell D5, and a Plus sign(+) will pop up.
• Left-click the Plus sign(+) two times.

Read More: How to Copy SUM Formula in Excel

### Method 3 â€“ Using the Keyboard Shortcuts to Copy the Formula to the Entire Column

Step 1:

• Select cell D5 and copy the following formula to the Formula Bar:
`=C5*10%`

• Press Enter to get the increasing price of Apple. The price in questionÂ is \$139.10.

Step 2:

• Select cell D5 to cell D14 and press Ctrl+D on your keyboard.

• Press Enter to get the desired output in Column D.

### Method 4 â€“ Inserting the Array Formula to Copy the Formula to the Entire Column

Steps:

• Select cell D5 and copy the following formula to the Formula Bar:
`=C5:C14*20%`

• Press Enter to get the desired output in column D, as shown in the screenshot below.

### Method 4 â€“ Using the Copy-Paste Method to Copy the Formula to the Entire Column

The task is to calculate the increasing 20% price of the fruit given in Column C5.

Step 1:

• In cell D5, enter the following formula:
`=C5*20%`

• Press Enter to get the return of the formula of \$278.20 in cell D5.

Step 2:

• Click on cell D5 and press Ctrl+C on your keyboard.
• Select the entire column from cell D5 to cell D14.

• Press Ctrl+V on your keyboard to get the desired output shown in the screenshot below.

### Method 6 â€“ Applying the Ctrl+Enter Method to Copy the Formula to the Entire Column

The task is to calculate the increasing 30% price of fruit outlined in the Column C.

Steps:

• Select cell D5 to cell D14.

• Copy the following formula to the Formula Bar:
`=C5*30%`

• Press the Ctrl+Enter buttons on your keyboard simultaneously to see the desired result in Column D.

### Automatically

Steps:

• Select the range where you want to create the table.

• Press Ctrl+T on your keyboard, and a Create Table box will pop up. Press OK to continue.

• Choose any blank cell on the selected table to enter the following formula:
`=[@[January]]*30%`

• Press Enter to get the desired output shown in the following screenshot:

## Things to Remember

You can use keyboard shortcuts like Ctrl+C, Ctrl+D,Â and Ctrl+V to copy formulas to an entire column in Excel.

You can use these options to copy a formula to the entire column in Excel: Home â†’ Editing â†’ Fill â†’ Down.

## Related Articles

<< Go Back to Copy Formula in Excel | Excel Formulas | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF