From time-to-time customers have to add numerous formulation for computing values in Microsoft Excel. In a state of affairs like this, the person may have the providers of the identical formulation in one other cell, row, or column. It is unnecessary to insert the formulation in every cell one after the other if there may be another.
When you’re questioning, we will say for sure that options do exist. And as you would possibly anticipate, we’re going to focus on a few of them to make life a lot simpler for all who’re .
How to apply Same Formula to Multiple Cells in Excel
To repeat the identical formulation to different cells in Excel is simple, and you need to use keyboard shortcuts, AutoFill or Copy and Paste command.
1] Copy the identical formulation to different cells in Excel utilizing keyboard shortcuts
It’s attainable to use keyboard shortcuts to simply add formulation to different components of a workbook. So, allow us to check out what wants to be executed proper now.
CTRL + Enter
With this keyboard shortcut, the person will write a single formulation in a specific cell. For instance, we might use D3, then use the identical formulation over the complete cell vary of D3 to F8.
To start, it’s essential to choose the cell vary from D3 to F8.
After choosing the vary of cells, instantly the primary cell will turn into the lively cell.
In order the image suggests, the D3 cell is lively whereas the non-active cells in the vary are greyed out.
Subsequent, it’s essential to kind the next formulation:
=$C5*C$12
Bear in thoughts you need to use no matter formulation you want.
As soon as executed, please press CTRL + Enter to populate the opposite non-active cells.
CTRL + R
This shortcut is designed to apply a single formulation to columns situated on the fitting. The draw back is, you possibly can solely apply the formulation to one column at a time, however it’s higher than having to kind the formulation time and again.
To get this executed, please kind the next formulation in the D3 cell, or whichever cell works finest for you:
=$C5*C$12
After that, press the Enter key in your keyboard.
Subsequent, it’s essential to choose a column to the fitting of Column D, then press CTRL + R.
The outcomes ought to seem in your display, as simple as you want.
2] Apply Same Formula to Multiple Cells in Excel utilizing AutoFill function
Right here we’re on the second method that works fairly properly, so allow us to focus on this proper now.
So, the thought right here is to kind the formulation in a single cell, then drag the formulation in direction of the complete cell vary, or those you need to use. For instance, D3 to F8, or no matter you’re feeling is finest at the moment.
- Start by inserting the formulation into D3.
- When that’s executed, you will notice a plus signal on the backside of the cell, proper on the nook.
- You’ll solely see the plus signal when the mouse is hovered there.
- From there, drag the plus signal to the cells which are decrease till you’re at D8.
- You’ll discover that one other plus signal seems in the fitting part of column 8.
- Drag it in direction of the cells to the fitting to cowl up to F8.
Doing it will make sure the formulation will get copied over to all the specified cells.
3] Enter similar information into a number of cells utilizing Copy and Paste Command
The standard copy and paste methodology can be utilized right here, however with a twist that enables the person to paste in a number of cells relatively than one after the opposite.
- To do that, it’s essential to kind the formulation into the related cell, for instance, D3.
- After that, copy the formulation, then choose the cell vary.
- This may be from D3 to F8.
- As soon as the vary is chosen, you possibly can then paste the code and it’ll seem inside every of the chosen cell.
READ: How to Mail Merge from Excel to Outlook
How do you repeat a formulation in Excel?
Select the cell with the related formulation that sits adjoining to the cells you need to fill. From there, click on on Residence, then Fill, and be certain to click on on both Down, Proper, Up, or Left. You should utilize keyboard shortcuts to reminiscent of CTRL + D to fill cells in the downward vary, or t the fitting with CTRL + R.
How do I repeat an motion in all cells in Excel?
So as to repeat a easy motion in Excel reminiscent of pasting, please press CTRL + Y, or F4. You can too use the mouse to click on on Repeat by way of the Fast Entry Toolbar.
