> set a formula for the entire column Spreadsheet power users on both excel and sheets do exactly that. It’s called array formula. Press cmd-shift-enter on the

> set a formula for the entire column Spreadsheet power users on both excel and sheets do exactly that. It’s called array formula. Press cmd-shift-enter on the cell with the formula and it’s valid for the entire column and can be changed in one central place.