You are probably tired of this type of question, but here goes.

Is there any way to quickly go through a spreadsheet with the

F2 Enter (to refresh a cell) I have tried a Macro, as well as the copy
and paste special with the Multiply which works for format dates etc. I
want to refresh the blank cells that once had a formula, so it will not be
included in COUNT.

Thanks