Donate SIGN UP

Microsoft Excel

Avatar Image
devadiva | 15:07 Tue 05th Aug 2014 | Computers
4 Answers
Help - I have been using the above program for years and find myself having a very senior moment. I just cannot remember how to show the formulae on the spreadsheet. Can anyone put me out of my misery
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by devadiva. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Tools > formula auditing > formula auditing mode.

when you print (or print preview) the cells will contain the formula rather than the result of calculating the formula. Is this what you want?
If you just click on any calculated cell the formula should appear at the top
i think control + accent key (left key to 1) is a short cut
Question Author
thank you, \i shall give them all a go tomorrow

1 to 4 of 4rss feed

Do you know the answer?

Microsoft Excel

Answer Question >>