Share this article...

Here's a quick way to see where all the formulas are in a spreadsheet

Microsoft Excel Tips

Take a look at this example part of a spreadsheet...

VAT Calculator

How can you instantly see where all the formulas are?  You could try clicking on each cell with a number in it and then look in the formula bar at the top.

This could be a laborious process - especially if it's a spreadsheet you have inherited.

However there is a much simpler way...

Whilst holding down the Ctrl key just hit the ` key (This key is usually found left of 1 and underneath the Esc key)

So you will now see this section of the spreadsheet looks like this...

Showing Formulas

You can instantly see all the formulas in the spreadsheet.

How do I put it back to the 'normal' view?

Just do Ctrl+` again and it will toggle back to the 'Normal' view (hiding the formulas and show you the results again).

What about Excel on my Mac?

Use a combination of the  and ` keys

 

Share this article...
Was this article helpful? Add your comment below...

Design Your Excel Training

checklist

Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 196

    Will has awarded Dominic a Virtual...

  • Thanks No. 195

    Tricia has awarded Dominic a Virtual Beer because "Very kindly did a marathon cleanup for us...

  • Thanks No. 194

    Sandra has awarded...

  • Thanks No. 193

    Amanda Davies has awarded Barry a Virtual Car because "he doesn't ever give up, he always manages...