🔢 Category

Formulas Shortcuts for Google Sheets

Work with formulas and functions using keyboard shortcuts. Browse all 6 shortcuts below.

Ctrl + ~
Show All FormulasToggle between showing cell values and showing the formulas in every cell.
Ctrl + Shift + Enter
Insert Array FormulaEnter an array formula that can return results across multiple cells.
Ctrl + Shift + E
Collapse or Expand Formula BarToggle the formula bar between collapsed and expanded view.
Shift + F1
Show or Hide Formula HelpShow or hide the formula help tooltip when editing a formula.
Ctrl + Up / Ctrl + Down
Resize Formula BarResize the formula bar to show more or fewer lines of your formula.
F4
Absolute Reference (Toggle)Cycle through absolute ($A$1), mixed ($A1, A$1), and relative (A1) cell references.

📚 Explore All Google Sheets Shortcuts

Discover all 111 keyboard shortcuts across 8 categories

View All Shortcuts ➜

Browse Other Categories

⚡

Common Actions

Essential everyday shortcuts for Google Sheets productivity.

25 shortcuts

🎨

Formatting

Format cells, text, and numbers quickly with keyboard shortcuts.

24 shortcuts

🧭

Navigation

Navigate spreadsheets efficiently with keyboard shortcuts.

17 shortcuts

📊

Rows & Columns

Insert, delete, hide and manage rows and columns.

14 shortcuts

💬

Notes & Comments

Add notes, comments, and collaborate with your team.

6 shortcuts

📋

Menus

Open and navigate menus using keyboard shortcuts.

13 shortcuts

♿

Accessibility & Screen Readers

Accessibility shortcuts for screen readers and braille support.

6 shortcuts