Sign up to hear about free Excel training.
I won't share your email with anyone.
One technique to “save” the formula is to copy cell formulas to a cell Note or Comment.
Here is an automated way to do it.
Macro solution
The macro below works with the current range selection. It saves each cell’s formula to a cell comment(note). It won’t overwrite any existing notes. If no note exists it creates a new note. The formula is appended to the bottom of any existing notes.
