Excel shortcuts

The Best Way to Show Formulas in Excel: A Shortcut Guide

If you're anything like me, you're always looking for ways to make your life easier. And when it comes to Excel, there are a ton of shortcuts that can save you time and make your workflows more efficient. One of the things I often find myself doing in Excel is showing formulas. Whether I'm trying to troubleshoot a formula or just want to see what's going on behind the scenes, being able to quickly show formulas can be a huge time saver.

There are a few different ways to show formulas in Excel, but my favorite is using the shortcut key Ctrl + `. This shortcut will toggle the display of formulas on and off, so you can quickly see what's going on without having to go into the menus. And if you want to take it a step further, you can use the Ctrl + Shift + ` shortcut to show formulas and their values. This can be helpful if you're trying to track down a specific value in a large worksheet.

If you're not a fan of shortcut keys, you can also show formulas by going to the Formulas tab and selecting the Show Formulas option in the Formula Auditing group. You can also find this option by going to File > Options > Advanced and scrolling down to the Display section. Just check the Show Formulas in Cells Instead of Their Values option and you're all set.

Once you've got the formulas displaying, you can use the Ctrl + F shortcut to find a specific formula, or you can use the Find and Select feature by going to the Home tab and selecting Find & Select > Go To. This will open the Go To dialog box where you can select the Formulas option to see a list of all the formulas in the active worksheet. You can then select the formula you want to jump to and hit OK.

If you want to take things a step further, you can use the Trace Precedents and Trace Dependents features to see how a formula is being used. These features can be found in the Formulas tab, in the Formula Auditing group. Just select the cell with the formula you want to trace and click the Trace Precedents or Trace Dependents button, depending on what you want to see. This will show you all the cells that are used in the formula, or all the cells that use the formula, respectively.

You can also use the Error Checking feature to find errors in formulas. This feature can be found in the Formulas tab, in the Formula Auditing group. Just click the Error Checking button and Excel will scan the active worksheet for errors. You can then click the Next button to see each error one by one and decide how you want to handle it.

As you can see, there are a few different ways to show formulas in Excel. And while the shortcut key method is my personal favorite, all of these methods can be helpful in different situations. So next time you're working with formulas in Excel, give one of these methods a try and see how it can save you time.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.