Displaying formulas on a printout

[Dumbfounded]

Hi - can anyone tell me if there's a way of displaying the answer in a cell but also show the formula?

Thanks in advance.

Donna

 

[Dumbfounded]

Solved! Played around and it's in Tools, Options, View tab, check formulas - hoorah.

 

[NBVC]

You can't show a result and the formula at the same time.

You can copy the formula into an adjacent cell and precede it with an apostrophe so that it becomes a text string.

or you can toggle between formula and result by holding the CTRL key and hitting the tilde (~) key above the TAB key.