This post explains that how to apply an excel formula in entire column or row through dragging fill handler in excel. How do I apply formula in entire column or row without dragging fill handler by shortcut or Fill command.
Assuming that you want to apply a formula to large number of column cells or entire row. You can directly drag the AutoFill handle to all other cells. But if you want to apply a specific formula to hundreds of rows or columns and it should be a very boring or tedious job. So you can use apply formula without dragging by using short cut or Fill Command.
Table of Contents
1. Dragging AutoFill Handle to apply formula
You can use AutoFill Handle to apply one formula to an entire column or row, assuming that you want to apply one formula to the entire column C, just refer to the follow steps:
1# enter the formula in the first cell in column C.
![apply formula without drag1](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag1.jpg)
2# click “AutoFill Handle” down to the bottom in column C.
![autofill handle1](https://www.excelhow.net/wp-content/uploads/2018/01/autofill-handle1.jpg)
![apply formula without drag1](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag2.jpg)
You will see that then entire cells in column is applied.
If you want to apply the same formula in the entire row, you just need to drag the AutoFill Handle to right most cell.
2. Using shortcut key to apply formula
If you want to apply a formula to the large number of column cells or entire row, you can use the AutoFill Handle, but it is not a good choice. At this moment, you can use shortcut keyboards to apply formula in the entire column or row. Let’s refer to the following steps:
1# click Column C to select the entire Column C.
![apply formula without drag3](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag3.jpg)
2# enter the formula in the formula text box.
![apply formula without drag4](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag4.jpg)
3# press “CTRL” +Enter keys
![apply formula without drag5](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag5.jpg)
You will see that the whole Column C is applied to the same formula.
3. Using Fill command to apply formula
You can also use the Fill command to apply a formula in the whole column or row without dragging AutoFill handle. Just refer to the following steps:
1# enter a formula into the first Cell of the Column C (Cell C1).
![apply formula without drag1](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag1.jpg)
2# select the whole Column C.
![apply formula without drag6](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag6.jpg)
3# Click “Down” from the drop down list of “Home”->”Fill” command.
![apply formula without drag7](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag7.jpg)
![apply formula without drag5](https://www.excelhow.net/wp-content/uploads/2018/01/apply-formula-without-drag5.jpg)
If you want to apply the formula to the whole row, you just need to repeat the above steps, just need to select the entire row in the step2. Then click “Right” in the step 3.
4. Video: apply a formula in entire column or row
This excel video tutorial, we’ll uncover efficient methods to apply formulas across entire columns or rows in Excel, providing you with time-saving techniques for large datasets.
Leave a Reply
You must be logged in to post a comment.