How To Show Formula In Excel

Hey there! If you’ve ever wanted to show the formula in Excel instead of the resulting value, you’re in the right place. I’ve got you covered with a step-by-step guide. Let’s dive in!

Using the Formula Bar

First things first, let’s head over to the formula bar. You can find it at the top of the Excel window. Once you click on a cell containing a formula, the formula will appear in the formula bar. It’s super handy for quickly checking or editing formulas without having to navigate through the cells.

Shortcut Key

As a quick tip, pressing Ctrl + ` (backtick) will also allow you to toggle between displaying the formula and the formula result. It’s a nifty shortcut that can save you some time, especially when you’re working with a large dataset.

Show Formulas Option

If you want to show all formulas at once, Excel has a neat feature for that. Head over to the “Formulas” tab on the ribbon, and then click on “Show Formulas” in the “Formula Auditing” section. Voila! Now you can see all the formulas in your spreadsheet without having to click on each individual cell.

Using a Custom Shortcut

For those who prefer customization, you can create a custom shortcut for showing formulas. Simply go to the “File” tab, then select “Options” and choose “Quick Access Toolbar.” From there, you can customize the toolbar to add the “Show Formulas” command, and even assign it a custom shortcut key for quick access. This way, you can breeze through your formulas with your personalized shortcut.


So there you have it – several methods to show formulas in Excel. Whether you prefer using the formula bar, toggling with shortcut keys, or customizing your own shortcuts, Excel gives you the flexibility to work with formulas in a way that suits you best. Happy formula displaying!