Display formula values

Peter Rattigan

Board Regular
Joined
Oct 18, 2004
Messages
77
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
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

bertie

Well-known Member
Joined
Jun 12, 2009
Messages
1,869
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,704
Messages
5,524,416
Members
409,576
Latest member
az168

This Week's Hot Topics

Top