How to insert column formula in excel for entire column
A free Office suite fully compatible with Microsoft Office


The heart and soul of an Excel spreadsheet are its formulas. Additionally, you typically don't require the formula in just one or a few cells. The formula would often need to be applied to a full column (or a large range of cells in a column).
By double clicking on the autofill handle in excel online, 2016 and 2019
Using this basic mouse double-click technique is one of the simplest methods to apply a formula to a whole column.
1. Consider the following dataset, where you wish to determine the commission for each sales representative in Column C. (where the commission would be 15 percent of the sale value in column B).
2. For this, the equation would be:
=B2*15%
3. The steps for applying this formula to all of column C are listed below:
4. Put the following equation in cell A2: =B2*15 percent
5. When the cell is selected, a tiny green square will appear in the bottom-right corner of the selection.
6. The little green square with the pointer over it. The cursor transforms to a plus sign, as you will see (this is called the autofill handle)
7. Press the left mouse button twice.
The aforementioned actions would automatically fill the column up to the cell containing the data from the neighbouring column. The formula would be applied to cell C15 in our case.
By dragging the auofill handle in excel
The aforementioned double-click technique has the drawback of stopping as soon as it reached a blank cell in one of the neighbouring columns.
1. Put the following equation in cell A2: =B2*15 percent
2. When the cell is selected, a tiny green square will appear in the bottom-right corner of the selection.
3. The little green square with the pointer over it. The cursor transforms to a plus sign, as you will see.
4. Holding down the left mouse button, move it to the cell where you wish to apply the formula.
5. After finished, release the mouse button.
Using the fill down option in excel
Using the fill down option on the ribbon is another approach to apply a formula to the full column. You must first choose the cells in the column where you want the formula to appear for this approach to function.
1. Put the following equation in cell A2: =B2*15 percent
2. To apply the formula, select each and every cell (including cell C2)
3. Click on the home tab.
4. Click the Fill icon in the editing group.
5. Click on fill down.
The previous stages would use cell C2's formula to fill in all the chosen cells.
Note: This was an attempt to show you how to add column formula by using different methods in excel online, 2016 and 2019, in both windows and mac.
To get the newest version of WPS Office, you must first access this operating interface.
You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.
Also Read:
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences