CODE EXAMPLE FOR EXCEL

google sheets apply formula to entire column

Click on the cell with the text/formula to copy
Shift+Click on the last cell to copy to
Ctrl + Enter (or CMD + Enter on Mac.)