Excel – How to set Function “formula” for whole column in Excel 2007

microsoft excelmicrosoft-excel-2007worksheet-function

I want to set "Formula" to all cells in certain column whatever the number of rows was.

But i don't want to set this function to first cell "Header" of this column.

How do i make it ?.

Best Answer

If your header is in cell A1 and your formulas need to start in A2 and go to the end, start by selecting A2, press (and release) "End" then press "Shift+Down Arrow". Now everything from A2 to the end is selected and you can paste your formula. If you have no data in A2-A65535, you will select the entire range. If you have data, this will only select to the end of the list of data.

Related Question