Here’s an extension: when you’ve got that whole column highlighted, if you want to change every formula (or value) in the column to be the same, just type it in and hit Ctrl-Enter–will apply your changes to all highlighted cells, as if you’d used a copy-paste. Works on more than just columns, by the way.