The formula will be copied to the cells below (up to the cell where adjacent column data is available).

When we will do so, cell references will also change according to the types of references we have used in the formula.

Insert Equation In Excel Download The Working

Table of Contents Download Working File Applying the same Excel formula to multiple cells (cell references will change) 1) Using CTRL Enter Keyboard Shortcut 2) Using Excel Fill Handle Tool (Dragging) 3) Using Excel Fill Handle Tool (Double click) 4) Using Copy and Paste Command (CTRL C) 5) Using Keyboard Shortcut CTRL D 6) CTRL R keyboard shortcut to apply the formula on the column to the right 7) Copying a formula to multiple cells but the cells are non-adjacent 8) Using an Excel Table Learn some important keyboard shortcuts 1) CTRL SHIFT END 2) CTRL SHIFT DOWN ARROW to select the column data from the cell where you are 3) CTRL SPACE will select the whole column Related Readings Conclusion Download Working File At first, download the working file that I have used to make this tutorial.

How-to-apply-same-formula-to-multiple-cells-in-Excel Applying the same Excel formula to multiple cells (cell references will change) In more than one way, you can apply an Excel formula to multiple cells (cell references will also change).

Use the method that best suits your purpose.

Using CTRL Enter Keyboard Shortcut You are seeing a sample data in the picture below.

The prices of some products (in Euro) are given under the Price (Euro) column.

What I want is to show the prices of the products in other currencies such as USD, GBP, and JPY.

I will write just one formula in the cell C6 and will use it over cell range C6: E10.

When you select a range of cells, the first cell becomes the active cell.

You see the other cells in the range are in grey color (not active).

This formula will be automatically entered into the cell C6 as C6 is the active cell.

B6 reference means that when the formula will be copied to the right, column B will not change.

All are B6 as when the formula is copied to right, the row is not changing.

When the formula will be copied down, the cell reference will be B6, B7, B8, B9, B10.

This is because the rows change when you copy down a formula.

C2 reference means that when the formula will be copied to the right, the references will be C2, D2, and E2.

And when we shall copy this formula down, the references will be C2, C2, C2, C2, and C2.

I select cell reference D8 and press the F2 key (this takes the cell to Edit mode) on the keyboard.

The formula is working perfectly.

Using Excel Fill Handle Tool (Dragging) I will use the same example to explain this method.

This time, I will select only the cell C6 and enter this formula: B6C2.

We shall get value 7.10 in the cell C6.

Again, select the cell C6.

You will see a green color solid square at the bottom right corner of the cell.

Insert Equation In Excel Plus Sign Will

The big white plus sign will turn into a small black sign Click and hold your mouse pointer and drag down.

I will not explain how the formula works because it is already done in the above method.

Using Excel Fill Handle Tool (Double click) You can also double-click on the Fill Handle tool.

How To Insert Equation In Excel For Mac