shortcut to apply a formula to an entire column in excel
Select the top cell and double-click the drag square (bottom-right).
This copies the top cell all the way down until the data end.
Another thing: you can select a large range and type the formula
in the Formula Bar and confirm with Ctrl-Enter.