How to use F2 + F9 + Enter for entire Worksheet

[jeffreyp]

I have three columns in a worksheet with formulas that resemble: ="+'"&$B5&"'!H5"
I can do F2, F9 Enter for each cell to get them to calculate but how can I do this for the entire worksheet at once?

 

[jeffreyp]

Doing that with the existing set up worked for me.
• Select formula area
• Copy Paste Values
• Find & Replace "+" with "="

Sorry I didn't get back to you until now. I had some other fish to fry! This worked perfectly. Thank you and all for your input!

 

[Alex Blakenburg]

No worries. Glad we were able to help.