Updated: 05/01/2023 by Computer Hope
Ctrl+` or Ctrl and backquote keyboard shortcut

The Ctrl+` or Ctrl+~ keyboard shortcut is most commonly used in Microsoft Excel to changes between displaying cell values or formulas. Below are other programs that use this keyboard shortcut and related information.

How to use the Ctrl+`

To use this keyboard shortcut, press and hold either Ctrl and Shift key, and while continuing to hold them, press the ` (back quote) key.

Ctrl+~ in Google Sheets

Pressing Alt+~ in a Google Sheets to reveal all formulas in the sheet. To return to showing the values instead of the formulas, press the keyboard shortcut again.

Ctrl+` in Microsoft Excel

Pressing Ctrl+` changes between displaying cell values or formulas in the worksheet.

Below are links to related keyboard shortcuts and individual key pages.

Back quote, Keyboard shortcut, Keyboard terms