🔢 Category

Formulas Shortcuts for Google Sheets

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

Ctrl + ~

Windows / PC

Show All FormulasToggle between showing cell values and showing the formulas in every cell.

Ctrl + Shift + Enter

Windows / PC

Insert Array FormulaEnter an array formula that can return results across multiple cells.

Ctrl + Shift + E

Windows / PC

Collapse or Expand Formula BarToggle the formula bar between collapsed and expanded view.

Shift + F1

Windows / PC

Show or Hide Formula HelpShow or hide the formula help tooltip when editing a formula.

Ctrl + Up / Ctrl + Down

Windows / PC

Resize Formula BarResize the formula bar to show more or fewer lines of your formula.

F4

Windows / PC

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 to speed up your workflow and boost your productivity.

View All Shortcuts ➜

⚡ Accelerator Keys

Accelerator Keys shows you browser shortcuts the moment you need them - no cheat sheets, no memorizing.

Add to browser - it's free

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