69. Excel Tips - Show Formulae

Nick's picture

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.

Download sheet to practise how to Show Formulae in Excel


Training Video on how to Show Formulae in Excel:

show-formulae.xls17 KB