How do i apply a formula to an entire column in Excel

I am new to Excel and would like to apply one formula to an entire column. How can this be done?


If there is column that is full to the left of the column you want to fill, then once you have typed your formula in the top cell, then double click on the bottom right corner of the cell. This will propagate the cell down to the last none empty cell you have in the in the left column.

If you don't have a column filled on the left, then you can also type the first cell and then select the full column and press CTRL-D. This will propagate it to the last cell of the sheet.

Other excel answers



You can find similar Excel Questions and Answer hereunder

1) Split one long column into multiple smaller columns in Excel

2) How do I enter a formula in a cell using VBA (using Absolute Reference)?

3) I have to retrieve data from a specific column in a Table. In Excel, how can I do that?

4) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

5) One of my formulas has returned an error - how can I trace the error to fix it?

6) Vba clear the contents of an entire sheet in Excel

7) I have a cell with nested formulas that returns an error. In Excel, how can I step through the formulas to help with debugging?

8) How to find the column number from the cell address in VBA

9) Formula converts date to quarter and year in Excel

10) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?


Here the previous and next chapter