How to apply a formula in entire column or row without/with dragging

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.

Apply formula in entire column or row quickly

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.

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

2# click “AutoFill Handle” down to the bottom in column C.

autofill handle1

apply formula without drag1

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.

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

2# enter the formula in the formula text box.

apply formula without drag4

3# press “CTRL” +Enter keys

apply formula without drag5

You will see that the whole Column C is applied to the same formula.

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

2# select the whole Column C.

apply formula without drag6

3# Click “Down” from the drop down list of “Home”->”Fill” command.

apply formula without drag7

apply formula without drag5

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.

Related Posts

Fix #N/A Error For VLOOKUP From Another Sheet
vlookup from anther sheet not working1

This post will show you how to fix the #N/A error why it occurs when you extract values from another sheet using VLOOKUP function in Excel 2016,2013,2010 or other Excel versions. How can you correct a #N/A error in VLOOKUP ...

How To Remove Special Characters in Excel
remove special character2

This post will show you how to remove special characters from text strings in Excel. And I am going to introduce two ways to remove special characters (@&)#%$) from a string in Excel. Removing Special Characters using Power Query If ...

How To Insert Comments in Protected Worksheet in Excel
insert commetns in protected workshee3

This post will show you how to allow comments in a protected worksheet in Excel. You can easily to insert comments into cells in a normal worksheet in Excel, but if want to insert a comment in a worksheet that ...

How To Convert Text to Upper Cases(Using VBA) in Excel
convert text to upper cases1

This post will show you how to switch from lower case to upper case in Excel. and I am going to show you two different ways of converting text to upper cases using formula or VBA macro in Excel 2013,Excel ...

How To Hide Every Other Row in Excel (Using VBA)
hide every other row1

This post will show you how to hide alternate rows or columns in Excel or how to hide every third, fourth, fifth row or column in Excel. If you want to hide every other row in your current worksheet, how ...

Get the Current Workbook Name
Get the Current Workbook name5

This post explains how to get the current workbook name in excel. Get the Current Workbook Name In excel, the CELL function can get the information of the current worksheet, it will return the full file name and its path. ...

Split Text and Numbers in Excel
Split Text and Numbers in Excel4

This post explains how to split text and numbers in excel, or how to extract the text characters from another strings with text and numbers combined. Split Text and Numbers If you want to split text and numbers, you can ...

Split Text String by Specified Character in Excel
Split Text String by Specified Character2

This post explains how to split text string by a specified character (such as: comma, space, dash, slash, etc.) using FIND function within other functions in excel. And you will learn that how to extract part of characters to the ...

Excel Replace Function Remove Text String
Excel Replace Function Remove Text String1

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you ...

Combining the REPLACE Function with FIND Function to Remove Text in Excel
Combining the Replace function with Text function 2

How to remove a text string or characters from a cell when the text is at a specific position. And this post will guide you how to remove a text string from a cell or column that the removed text ...

Sidebar