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...

Coronavirus COVID-19 Pandemic Policy

Design Your Excel Training

checklist

Say Thank You

Has somebody at Easykey impressed you?

Pick a Reward

Customer Thanks

  • Thanks No. 217

    Linda has awarded Barry a Virtual Cake because "Always quick and efficient and most helpful....

  • Thanks No. 216

    Sarah at CSEL has awarded...

  • Thanks No. 215

    Sharon has awarded...

  • Thanks No. 214

    Ruth has awarded Barry a Virtual Tea because "As always with Easykey, Barry was once again the...