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
- 8304 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago