Quickest way to apply a formula to an entire column?
You can follow these steps: Write the formula in the first cell. Click Enter. Click Ctrl+Shift+End. This will select the last right cell used on the worksheet. Ctrl+D. This will fill the value in the remaining cells. Source at Zyxware