# 6+ Ways to Copy a Formula in Excel with Changing Cell References

Do you want to copy a formula in Excel with changing cell references? – Well there is a number of ways to do that. In this article, I will be showing you 6+ easy methods to solve your problem of copying formulas with changing cell references.

But before moving into the tutorial, think you all know what is a cell reference and you also know the cell reference is like a variable used in a formula.

## Introduction to the Dataset

I am going to use a dataset of the sales record of an electronics shop. The shop imports its products at a fixed price and sells them with a 1.5times profit. ## Quickest Way to Copy a Formula in Excel with Changing Cell References

The quickest method literally takes 2 seconds to copy a formula with changing cell references.

Step_1: Select an empty cell.

I selected D2.

I used the following formula in my data table:

`=C2*1.5` Step_3: Press ENTER to apply the formula.

Step_4: Put the mouse cursor on the right-bottom corner of cell D2.

The Fill Handle ‘+’ sign will show up instead of the cursor arrow.

Step_5: Double-click on the Fill Handle icon. Final Result ↓

The Fill Handle has done its job of copying the formula all through column D with changing cell references. 🔗 9 ways to Copy Formula Down in Excel without Dragging

### Alternative Way #1: Drag Down Fill Handle to Copy a Formula in Excel with Changing Cell References

This method is also about Fill Handle. But this time you can control the Fill Handle manually by dragging it down through as many as cells you like.

Step_1: Type the formula in cell D2. Step_2: Press ENTER.

Step_3: Take the mouse cursor on the right-bottom corner of cell D2.

The mouse cursor will turn into Fill Handle.

Step_4: Press on the Fill Handle with your left mouse button and drag it from cell D2 to D8. Final Result ↓

This way you can easily copy a formula throughout any column. 🔗 3 Ways to Copy a Formula in Excel without Changing Cell References

🔗 4 Ways to Fill Formula Down to Specific Row in Excel

### Alternative Way #2: Insert an Excel Table to Copy a Formula in Excel with Changing Cell References

The Excel Table is a pretty nifty feature. If you apply the Excel Table to your data table, and then apply a formula in any cell of a column, it will automatically copy the formula through the entire column.

Step_1: Select the entire data table.

### Step_2: Select Insert from the ribbon.

Step_3: In the Tables group, click on the Table option (Or, just press CTRL+T). A dialog box named Create Table will come along on the sheet.

Step_4: Check the My Table Has Headers checkbox has a checkmark.

Step_5: Click on OK. Now you will notice that your data table is arranged in an Excel Table. Step_6: Type a formula in cell D2.
Step_7:
Press ENTER. Final Result ↓

The formula will instantly copy down through the entire column D. 🔗 5+ Proven Methods to Copy a Formula to Entire Column in Excel

🔗 4+ Ways to Repeat Formula Pattern in Excel

### Alternative Way #3: Copy Multiple Formulas to Multiple Cells in Excel with Changing Cell References

Now let’s say, you want to copy multiple formulas in multiple cells with changing cell references. In that case, you will need to modify the cell references in the formula and then you are good to go.

Consider a situation where we have to find out the selling price of some imported electronic products in a shop. The shop increased the price of electronic products twice. At first, the price increase was 1.5 times and then the shop increased the price 2.5 times.

We will find out the Selling price after a 1.5 times increase (column D: Selling price 1) and 2.5 times increase (column E: Selling price 2) with one formula. Step_1: Type this formula in cell D6:

`=\$C6*D\$3` Formula Explanation:

• Here in \$C6, the dollar sign ‘\$’ is used before C, that’s because we want to fix the column number and want to move the row value. So, the \$C6 will change into \$C7, \$C8, \$C9, \$C10
• For about D\$3, you can see the dollar sign ‘\$’ is before 3. That means, the row number is not going to move for the formula but the column number will change. So If we drag the Fill Handle to the right, column D will be column E.

Step_2: Press ENTER.

Step_3: Double-click on the Fill Handle.

Step_4: Put the mouse cursor on the right-bottom corner of cell D12 and just drag the Fill Handle to the right side. Final Result ↓

This way you can multiply cell values in multiple cells using a single formula. 🔗 Apply Same Formula to Multiple Cells in Excel (5+ Solutions)

### Alternative Way #4: Use COPY-PASTE to Copy a Formula in Excel with Changing Cell References

Applying the same formula in multiple cells can be done in many ways. I am going to show you another easy way to copy a formula with changing cell references using the traditional COPY – PASTE method.

Step_1: Write a formula in cell D6.

Step_2: Press ENTER. Step_3: Select the cell and press CTRL+C.

Small dash marks will appear around the cell. Step_4: Select the cell range D6:E12 with the white ‘+’ sign cursor. Step_5: Press CTRL+V.

Final Result ↓

You will see the formula is now copied in the targeted cell range. But the small dash marks are still visible around cell D6. To remove the small dashes, click on cell D6 to select it and press ENTER.

You can also copy a formula in Excel to another sheet using the COPY-PASTE technique.

### Alternative Way #5: Copy a Formula in Excel with Changing Cell References but Cells Are Unadjusted

Sometimes you may face a situation where the cells are not adjusted but you want to copy a formula in the unadjusted cells to save your time. Good news! It’s possible.

Step_1: Apply a formula in the first cell of a column of unadjusted cells.

I applied the previously mentioned formula in cell D2. Step_2: Put your Fill Handle in the right-bottom corner of D2.

Step_3: Select the column (column D).

Step_4: Press CTRL+D. Final Result ↓

Now you have the formula copied with changing cell reference non-adjusted cells. 🔗 Copy Excel Sheet to Another Sheet with Same Format and Formulas

### Alternative Way #6: Use CTRL+D Keyboard Shortcut to Copy a Formula in Excel with Changing Cell References

Instead of using CTRL+C and CTRL+V, try to use CTRL+D from now. It’s even handier in terms of applying formulas in an entire column.

Step_1: Apply a formula in cell D6.

Step_2: Select the column (column D). Step_3: Press CTRL+D.

Final Result ↓

CTRL+D only works for cells on the downside. If you want to apply the formula in the right column of your data table, press CTRL+R. ## Also Learn: Fill a Series of Numbers to Autofill Serial Numbers in Excel

Microsoft Excel can automatically autofill a series of numbers with a fixed interval. You don’t have to write a number series manually anymore.

Step_1: Insert the first two (or more than two) values of your desired number series.

For example, I wrote a series of 5, 10, 15, and 20.

Instead of that, I could write the first two values of the series, 5 and 10.

Step_2: Select the number series B2 to B5. Step_3: Put the mouse cursor on cell B5, and the Fill Handle will come up.

Step_4: Drag the Fill Handle to the rest of the cells of the column. Final Result ↓

See how smoothly you can autofill a series of numbers of any interval. If you want to input just one value in a cell and want to fill the number series, it won’t work.

The selected cells will show the same value as that particular cell.

For example, I inserted value 5 in cell B2 and apply the method. The rest of the cells return the value 5 only. ## Conclusion

I hope the methods I have shown you in this article, will help you to solve your problems with copying any formula in Excel. If you have any confusion regarding this topic, please do share it with us in the comment section below.

Rate this post