Display formula values

[Peter Rattigan]

I am chasing a possible error in a very large worksheet which has some very complex formulas. I have been printing out the formulas and manually finding cell values to verify the formulas results. This is very time consuming and I was wondering if there is a facility that I have not yet found that will display a formula with resultant values for each component of the formula. I have tried using the Formula Auditing function- "Evaluate Formula" but that just keeps doing a step by step calculation. I just want the values so I don't have to hunt all over the worksheet looking for values.

Probably nothing exists to do it but I thought I would ask the question.

Cheers
Peter

 

[bertie]

There is a keyboard combination which will toggle between formula and cell values which may be of use to you:

CTRL + `

where (`) is a backwards single quote.

On my keyboard it is below the Escape key.