Excel Calcualtions - Report Showing all calculations contents -res

[Chris Andreou]

Greetings to all,

Is there is any way in Excel to get a report, that will display both the
contents as well as the result of any calculations and formulas withinthe
spreadsheet?

Best Regards

 

[JE McGimpsey]

Greetings to all,

Is there is any way in Excel to get a report, that will display both the
contents as well as the result of any calculations and formulas withinthe
spreadsheet?

There's no way to show both formulae and results in the same
view/printout.

You can print them individually (type CTRL-` to see the formulae).

If you want a separate sheet that lists both formulae and current
results, and you're using XL04, this might work for you. It won't work
with XL08, since it's a VBA solution.

http://mcgimpsey.com/excel/listfunctions.html