Question: how to make a formula on excel for a column?
Answer: Create a table. ... 
Insert a new column into the table. ... 
Type the formula that you want to use, and press Enter. ... 
When you press Enter, the formula is automatically filled into all cells of the column — above as well as below the cell where you entered the formula.