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: