---
title: "Show formulas instead of results: Ctrl+` in Excel (Mac Ctrl+`) | PracticeExcel"
description: "Show formulas instead of results in Excel with Ctrl+` on Windows or Ctrl+` on Mac. Practice it in a live grid."
canonical_url: "https://practiceexcelonline.com/shortcuts/show-formulas"
meta:
  "og:description": "Show formulas instead of results in Excel with Ctrl+` on Windows or Ctrl+` on Mac. Practice it in a live grid."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHM6IEN0cmwrYCBpbiBFeGNlbCAoTWFjIEN0cmwrYCk%2Cdescription_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHMgaW4gRXhjZWwgd2l0aCBDdHJsK2Agb24gV2luZG93cyBvciBDdHJsK2Agb24gTWFjLiBQcmFjdGljZSBpdCBpbiBhIGxpdmUgZ3JpZC4%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvc2hvdy1mb3JtdWxhcyI%2Cs_2yPa-Fx97346egc_.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Show formulas instead of results: Ctrl+` in Excel (Mac Ctrl+`) | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHM6IEN0cmwrYCBpbiBFeGNlbCAoTWFjIEN0cmwrYCk%2Cdescription_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHMgaW4gRXhjZWwgd2l0aCBDdHJsK2Agb24gV2luZG93cyBvciBDdHJsK2Agb24gTWFjLiBQcmFjdGljZSBpdCBpbiBhIGxpdmUgZ3JpZC4%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvc2hvdy1mb3JtdWxhcyI%2Cs_2yPa-Fx97346egc_.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.com/llms.txt)

# **Show formulas instead of results**

<dl><dt>**Windows**</dt>
<dd>`Ctrl+``</dd>
<dt>**Mac**</dt>
<dd>`Ctrl+``</dd>
</dl>

Ctrl+\`

Switches the whole sheet between showing results and showing the formulas behind them. Press it again to switch back. It is the quickest way to check which cells hold formulas and which hold typed numbers.

## **More Formulas shortcuts**

- [**Accept a suggested function**`Tab`](https://practiceexcelonline.com/shortcuts/accept-autocomplete)
- [**Enter an array formula**`Ctrl+Shift+Enter`](https://practiceexcelonline.com/shortcuts/array-formula)
- [**Insert AutoSum**`Alt+=`](https://practiceexcelonline.com/shortcuts/autosum)
- [**Recalculate all open workbooks**`F9`](https://practiceexcelonline.com/shortcuts/calculate-now)
- [**Recalculate the active sheet**`Shift+F9`](https://practiceexcelonline.com/shortcuts/calculate-sheet)
- [**Open Insert Function**`Shift+F3`](https://practiceexcelonline.com/shortcuts/insert-function)
- [**Toggle absolute and relative references**`F4`](https://practiceexcelonline.com/shortcuts/toggle-absolute)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://practiceexcelonline.com/shortcuts/show-formulas#webpage","@type":"WebPage","description":"Show formulas instead of results in Excel with Ctrl+` on Windows or Ctrl+` on Mac. Practice it in a live grid.","name":"Show formulas instead of results: Ctrl+` in Excel (Mac Ctrl+`)","url":"https://practiceexcelonline.com/shortcuts/show-formulas","breadcrumb":{"@id":"https://practiceexcelonline.com/shortcuts/show-formulas#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/shortcuts/show-formulas"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/shortcuts/show-formulas#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel keyboard shortcuts","item":"https://practiceexcelonline.com/shortcuts","position":2},{"@type":"ListItem","name":"Show formulas instead of results: Ctrl+` in Excel (Mac Ctrl+`)","position":3}]},{"@id":"https://practiceexcelonline.com/shortcuts/show-formulas#article","description":"Show formulas instead of results in Excel with Ctrl+` on Windows or Ctrl+` on Mac. Practice it in a live grid.","headline":"Show formulas instead of results: Ctrl+` in Excel (Mac Ctrl+`)","inLanguage":"en-US","thumbnailUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHM6IEN0cmwrYCBpbiBFeGNlbCAoTWFjIEN0cmwrYCk%2Cdescription_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHMgaW4gRXhjZWwgd2l0aCBDdHJsK2Agb24gV2luZG93cyBvciBDdHJsK2Agb24gTWFjLiBQcmFjdGljZSBpdCBpbiBhIGxpdmUgZ3JpZC4%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvc2hvdy1mb3JtdWxhcyI%2Cs_2yPa-Fx97346egc_.png","@type":["Article","TechArticle"],"author":{"@id":"https://practiceexcelonline.com/#identity"},"image":{"@id":"https://practiceexcelonline.com/#/schema/image/1"},"isPartOf":{"@id":"https://practiceexcelonline.com/shortcuts/show-formulas#webpage"},"mainEntityOfPage":{"@id":"https://practiceexcelonline.com/shortcuts/show-formulas#webpage"},"publisher":{"@id":"https://practiceexcelonline.com/#identity"}},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"},{"@id":"https://practiceexcelonline.com/#/schema/image/1","@type":"ImageObject","contentUrl":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHM6IEN0cmwrYCBpbiBFeGNlbCAoTWFjIEN0cmwrYCk%2Cdescription_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHMgaW4gRXhjZWwgd2l0aCBDdHJsK2Agb24gV2luZG93cyBvciBDdHJsK2Agb24gTWFjLiBQcmFjdGljZSBpdCBpbiBhIGxpdmUgZ3JpZC4%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvc2hvdy1mb3JtdWxhcyI%2Cs_2yPa-Fx97346egc_.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHM6IEN0cmwrYCBpbiBFeGNlbCAoTWFjIEN0cmwrYCk%2Cdescription_~U2hvdyBmb3JtdWxhcyBpbnN0ZWFkIG9mIHJlc3VsdHMgaW4gRXhjZWwgd2l0aCBDdHJsK2Agb24gV2luZG93cyBvciBDdHJsK2Agb24gTWFjLiBQcmFjdGljZSBpdCBpbiBhIGxpdmUgZ3JpZC4%2Ceyebrow_Excel%2Bkeyboard%2Bshortcuts%2Csite_practiceexcel%2Cp_Ii9zaG9ydGN1dHMvc2hvdy1mb3JtdWxhcyI%2Cs_2yPa-Fx97346egc_.png"}]}
```

## Sitemap

See the full [sitemap](https://practiceexcelonline.com/sitemap.md) for all pages.
