Visible Functions?

[Ili]

I have the worksheet that I need to print, but I have to show the functions, not the results. How do I do this?
If I have =D3*G5 and the result is 64, how do I show the Function, and not the result on the printout?

[Andy Pope]

Switch between displaying formulas and their values on a worksheet

Press CTRL + ` (grave accent).

[Ili]

Does this also work for 2007?

[Ili]

it's not working, it just doubles the width of the columns...

[Andy Pope]

Yes I tested in both xl2003 and 7

You can also set it using
Office button > Excel Options > Advanced > Display options for this worksheet > Show formula in cells instead of their calculated results

[squiggler47]

There is also a show formulas button under the Formulas tab on the ribbon!

[Excel Matic]

I think the key combination is - CTRL + ~

The second key is basically the one on the left of number 1 and above the TAB key. This will toggle between result view and formula view. I am not sure if this also has effect on the prints that you will take out.

Yes, it works absolutely fine with Excel 2007

[Ili]

Ok, thanks it works!