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.
- 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.
Training Video on how to Show Formulae in Excel: