Share

How to Put Formulas in Excel for a whole Column

 
By Sara . Updated: January 16, 2017
How to Put Formulas in Excel for a whole Column

If you use Excel on regular basis then you know how important formulas are. They are used in about every occasion and hence there are numerous columns which work on similar formula. Applying the same formula to each cell in that row is quite a tedious process. It would become much easier if we apply trick so that one input of formula works for the whole column. If you want to know the trick then keep reading this OneHowTo article How to put formulas in excel for a whole column.

You may also be interested in: How to calculate a percentage in Excel

Through AutoFill handle

To apply a single formula to the whole column, dragging the Autofill handle is the most common method.

  1. To use this trick at first select the Formulas tab. There click on calculation options. Then click on Automatic. This will cause the formula to calculate the value automatically.
  2. Now choose the formula you want to apply on the entire column.
  3. Then type the formula that you want to apply in the first Cell.
  4. Next step is to drag the AutoFill Handle down to the number of cells in the column you want to cover. AutoFill is a rectangle shaped box which can be dragged through its corners.
  5. That’s it. The formula is now applied to the entire column.

Through Fill

If you are tired of dragging through the whole column then this method will help you in achieving the same result without dragging.

  1. At first open an Ms Excel file. Under the home tab, go to the rightmost box on the Excel Ribbon. There you will find the option Fill under AutoSum.
  2. Now choose the formula you want to apply to the entire column and then type it into the first cell of that column.
  3. Then select the entire column by clicking on the alphabet above the column and then click on fill. There select the option Down.
  4. This will apply the formula to the entire column.

Through Shortcut Keys

If you don’t want to use Fill option and also don’t want to drag through the AutoFill then you can use Shortcut keys to use one formula for a whole column.

  1. First enter the formula in the first cell of the column in which you want to apply the formula.
  2. Then select the whole column by clicking on the alphabet on the top of the column.
  3. Then press Ctrl + Enter i.e. press the Control key and the Enter key together. Now the formula is applied to the whole column.
How to Put Formulas in Excel for a whole Column - Through Shortcut Keys

If you want to read similar articles to How to Put Formulas in Excel for a whole Column, we recommend you visit our Software category.

Write a comment about How to Put Formulas in Excel for a whole Column

What did you think of this article?

How to Put Formulas in Excel for a whole Column
1 of 2
How to Put Formulas in Excel for a whole Column

Back to top