The thing about spreadsheets is that the formulas keep updating themselves as the data they reference changes. You can freeze the values with a Copy / Paste Results (formerly Paste Values). That eliminates the formulas and effectively turns the cells into data rather than calculations. If you are clever about how you arrange these cells, you can Copy and Paste them as a group, to their "final resting place".
For completeness, it should be noted that an Applescript could be triggered with a Keyboard Shortcut to provide some automation, but you have to weigh the added complexity against the time it would take to do the simple task manually.