Troubleshoot Excel With Formula View

If you're working in Excel, there are times when things don't go right, and you have to do a bit (or a lot!) of troubleshooting. Lets look at a couple of quick ways to see the worksheet formulas, and a simple trick for seeing both the formulas and the results.

Use the Formula Bar

To drill into the formulas, the quickest and easiest way is to select a formula cell, and check the formula in the formula bar. In newer versions of Excel, you can make the formula bar taller, to its easier to work with long formulas.


Switch to Formula View

If you want to see all the formulas on a worksheet, instead of the results, you can use an Excel keyboard shortcut.

On the keyboard, press the Ctrl key, and tap the ` key (accent grave). On my keyboard, that key is at the top left, just above the Tab key.


The worksheet columns widen automatically, and you can see the formulas, instead of their results.


To go back to Normal view, you can press the Ctrl + ` keyboard shortcut again.

See Both Formulas and Results

Instead of switching between formula, you can open another window in the same workbook.

To open a second window, on the Ribbon's View tab, click New Window.


When multiple windows are open for the same workbook, you'll see a number after the file name in the Excel title bar.


To see both windows, you can arrange them. On the Ribbon's View tab, click Arrange All.


In the Arrange Windows dialog box, click Horizontal, then click OK.


Click in one of the windows, and press the Ctrl + ` shortcut, to see the Formula View in that window.


Watch the Formula View Video

To see the steps for switching to Formula View, and arranging multiple window, you can watch this short Excel video tutorial.

Or watch on YouTube: Troubleshoot Excel in Formula View


You may also like...

3 Responses

  1. Doug Glancy says:

    Debra, I was just using Ctrl+thing-under-the-tilde today, with multiple windows, but it didn’t occur to me to look at formula and regular view in two windows at the same time. Thanks to you, it will next time!

  2. Thanks Doug, and it’s easier than switching back and forth between Normal and formula view, especially with the column size changing.

  3. Missy says:

    How do I stop multiple highlighting of cells when you click on a single cell?

Leave a Reply

Your email address will not be published. Required fields are marked *