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

    Pam Shaw has awarded Lisa a Virtual Bunch of Flowers because "Lisa, as the 'front desk' person,...

  • Thanks No. 203

    Derk Collinge has awarded Barry a Virtual Wine because "He...

  • Thanks No. 202

    Barbara has awarded Dominic a Virtual Cake because "he was Very Clear & Helpful thank...

  • Thanks No. 201

    Colin has awarded Dominic a Virtual Beer because "Completed an MOT as...