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
How to Average Only Positive or Negative Numbers of a Range

Suppose both positive numbers and negative numbers exist in a table. If we want to know the average of only positive numbers in this table, we can create a formula to get average of all positive numbers with all negative ...

How to Sort Data but Keep Blank Cells in Excel

In daily work, if we sort data with blank cells included in the same column, these blank cells are listed at the bottom automatically after sorting. If we want to keep the positions of these blank cells unchanged and only ...

How to Copy and Paste Only Values and Ignore Formula

When we copy a cell applied with a formula, we copy the formula of the cell rather than copy the value showing in the cell. In this article we will introduce you the way to copy only value ignoring applied ...

How to Sort Date by Day of Week in Excel

Except sort data by “A to Z” (alphabetical order, for numbers from small to large), we can also sort data by date, month or year if these conditions are given. In this article, we will show you the way to ...

How to Select All Non-Blank Cells of a Range

In daily work, we may meet the cases that select all blank cells or non-blank cells of a range. You may know the way to select all blank cells as they are “blanks”. But for non-blank cells, they may contain ...

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