Excel shortcuts

15 Keyboard Shortcuts for Showing Formulas in Excel

Formulas are the key to getting things done in Excel. They're also the key to understanding how Excel works. Formulas show you the relationships between cells and allow you to perform calculations on data.

Unfortunately, formulas can also be confusing. They're often long and complicated, and they can be hard to read. That's why it's important to be able to view formulas in Excel.

There are a few different ways to view formulas in Excel. The easiest way is to use the keyboard shortcut Ctrl + `. This shortcut will toggle the formulas on and off.

If you want to see all the formulas in a sheet at once, you can use the shortcut Ctrl + Shift + `. This shortcut will highlight all the cells that contain formulas.

If you want to see the formulas for a specific cell, you can use the shortcut Ctrl + F3. This shortcut will open the Formula Auditing pane, which will show you all the formulas that affect the selected cell.

If you want to see the formulas for a range of cells, you can use the shortcut Ctrl + Shift + F3. This shortcut will open the Name Manager, which will show you all the named ranges in the workbook.

If you want to see the formulas for a worksheet, you can use the shortcut Ctrl + Shift + F11. This shortcut will open the Worksheet Properties dialog box, which will show you all the formulas in the worksheet.

If you want to see the formulas for a workbook, you can use the shortcut Ctrl + Shift + F12. This shortcut will open the Workbook Properties dialog box, which will show you all the formulas in the workbook.

If you want to see the formulas for a specific cell, you can use the shortcut F9. This shortcut will evaluate the selected cell and show you the formula that is being used.

If you want to see the formulas for a range of cells, you can use the shortcut Shift + F9. This shortcut will evaluate the selected cells and show you the formulas that are being used.

If you want to see the formulas for a worksheet, you can use the shortcut Alt + F9. This shortcut will evaluate all the formulas in the worksheet and show you the results.

If you want to see the formulas for a workbook, you can use the shortcut Ctrl + Alt + F9. This shortcut will evaluate all the formulas in the workbook and show you the results.

If you want to see the formulas for a specific cell, you can use the shortcut Ctrl + Shift + F9. This shortcut will force the selected cell to recalculate and show you the updated formula.

If you want to see the formulas for a range of cells, you can use the shortcut Ctrl + Alt + Shift + F9. This shortcut will force the selected cells to recalculate and show you the updated formulas.

If you want to see the formulas for a worksheet, you can use the shortcut Ctrl + Shift + Alt + F9. This shortcut will force all the formulas in the worksheet to recalculate and show you the updated results.

If you want to see the formulas for a workbook, you can use the shortcut Ctrl + Shift + Alt + F10. This shortcut will force all the formulas in the workbook to recalculate and show you the updated results.

These are just a few of the keyboard shortcuts that you can use to view formulas in Excel. For a complete list of shortcuts, see the Excel Keyboard Shortcuts page on the Microsoft website.

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.