Apply formula to the entire column

Question

I think it's a more recent feature, but it works for me:

Double clicking the square on the bottom right of the highlighted cell copies the formula of the highlighted cell.

Hope it helps.

It looks like some of the other answers have become outdated, but for me this worked:

1. Click on the cell with the text/formula to copy
2. Shift+Click on the last cell to copy to
3. Ctrl + Enter

(Note that this replaces text if the destination cells aren't empty)

I think you are in luck. Please try entering in B1:

=text(A1:A,"00000")

(very similar!) but before hitting Enter hit Ctrl+Shift+Enter.

This is for those who want to overwrite the column cells quickly (without cutting and copying). This is the same as double-clicking the cell box but unlike double-clicking, it still works after the first try.

1. Select the column cell you would like to copy downwards
2. Press Ctrl+Shift+⇓ to select the cells below
3. Press Ctrl+Enter to copy the contents of the first cell into the cells below

BONUS:

The shortcut for going to the bottom-most content (to double-check the copy) is Ctrl+⇓. To go back up you can use Ctrl+⇑ but if your top rows are frozen you'll also have to press Enter a few times.