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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,477
Messages
5,831,909
Members
430,090
Latest member
bjonesh2o

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top