69. Excel Tips - Show Formulae

Most regular Excel users have discovered today's functionality by accident, and ask what on earth has happened!
Heve you ever seen your Excel sheet do this ?:
What has happened is that you have changed the view from a normal one to one showing the formulae.
Solution:
- Press CTRL and button to the left of 1 to toggle back to normal view.
you will now see this:
I have only found one quite good use for this functionality, and will discuss in a later tip.
Download sheet to practise how to Show Formulae in Excel
Training Video on how to Show Formulae in Excel:
Attachment | Size |
---|---|
show-formulae.xls | 17 KB |
»
- Nick's blog
- Login or register to post comments
- 8385 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago