Quickest way to apply a formula to an entire column?

Question

I want each row in column B to be f( column A), so that b[n]=f(a[n]). I could go row by row and apply the formula, but is there an easy way to just drag the formula down and have it increment the cells it's referencing automatically?

Answer 1

This worked for me,

1. Write the formula in the top cell of a column.
2. Copy this cell
3. Select all of the rest of cells in the column. You can do this by clicking on the top cell and shift clicking on the bottom cell so the scrolling is really quick
4. With all of the cells selected select Paste. The formula will be copied to all of the currently selected cells, but will be adjusted according to its position in the sheet.

Answer 2

You can follow these steps:

1. Write the formula in the first cell.
2. Click Enter.
3. Click Ctrl+Shift+End. This will select the last right cell used on the worksheet.
4. Ctrl+D. This will fill the value in the remaining cells.

Source at Zyxware