I have a spreadsheet that makes calculations based on the value of another cell
(say, A1).
If I change the value in A1, all the calculations are updated, however, I want
certain cells to keep their values when saved, so that future changes to A1
aren't reflected in these cells.

I can currently do this on a cell-by-cell basis by hitting F2, then F9 on a
cell, but I'm wanting something a bit simpler and that will work when I select a
range of cells.
I've tried saving the F2, F9 presses as a macro, but that doesn't work...

Any ideas?