Quickest way to apply a formula to an entire column?


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?


Answers:


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