By Achilles Hill | Last Updated
In the modern office working, people usually use Excel to demonstrate some data reports. For saving time and improving working efficiency, some people would like to apply a formula to an entire column or row in excel. As far as I am concerned, manually typing a formula just fit the situation that you just want to apply a formula in one cell of the Excel table, but if you manually apply the same formula to all the cells or rows in Excel, that would be really an annoying thing. Then how can we apply a formula to the entire columns or rows in Excel? Just continue reading the below.
Now we suppose that you would like to apply a formula of A1*6-5 in the column B. Typically there are two ways to actualize this goal: dragging or not dragging autofill handle.
Step 1: Typing the formula in the first cell of column B.
We first type the formula into the cell B1.
Step 2: Dragging the autofill handle to the bottom of the target part in the column B.
Then I just drag the autofill handle to the bottom of the target part in the column B and then you can see that the formula is applied to the column B.
Attention: This dragging autofill handle method requires formula calculation automatically. If you find that the auto formula calculation feature is not enabled, you can enable it by clicking Formulas > Calculation OptionsAutomatic.
Beside dragging autofill handle to apply a formula, there are another ways to to archive it easily in Excel. Please follow my words.
We demonstrate using the shortcut keyboard to apply a formula to an entire column or row. We suppose that you have selected the column B and then you should just type the target formula in the function section and press Ctrl+Enter at same time to apply the formula.
If you don't want to use the shortcut keyboard, you can use the Fill feature in Excel to apply a formula in an entire column or row.
For example, you are supposed to apply the formula of =(A1*3+8)/5 to the entire column B. you should first type the formule into the cell B1, secondly select the entire column B, and then click Home > Fill > Down.
What's more, if you want to apply the formula to entire row, just enter the formula into the first cell of your entire row, next select the entire row, and then click HomeFillRight.
Related Links:
