Excel, Google Sheets & Shortcuts

Google Sheets Shortcuts and Formulas Cheat Sheet

First-party keyboard shortcuts and copyable Google Sheets formulas, with browser and operating-system differences noted.

Jurisdiction
Global — Google Sheets on computer
Applies to
Google documentation checked 16 November 2026
Last verified
16 November 2026

At a glance

  • Open the in-product shortcut list with Ctrl+/ on Windows/ChromeOS or Cmd+/ on Mac.
  • Some shortcuts vary by browser, keyboard language and operating system.
  • Array formulas can expand into neighbouring cells, so keep the spill range clear.

Useful shortcuts

ActionWindows / ChromeOSMac
Shortcut listCtrl+/Cmd+/
Tool finderAlt+/Option+/
Paste values onlyCtrl+Shift+VCmd+Shift+V
Select columnCtrl+SpaceCtrl+Space
Select rowShift+SpaceShift+Space
Fill downCtrl+DCmd+D
Insert dateCtrl+;Cmd+;
Show formulasCtrl+~Ctrl+~
Insert new sheetShift+F11Shift+F11

Formula patterns

TaskFormula
Conditional total=SUMIFS(C:C,A:A,F2,B:B,"Paid")
Filtered rows=FILTER(A2:C,C2:C="Open")
Query rows=QUERY(A1:C,"select A,sum(C) where B='Paid' group by A",1)
Array calculation=ARRAYFORMULA(IF(A2:A="",,B2:B*C2:C))
Lookup=XLOOKUP(E2,A:A,C:C,"Not found")
Import range=IMPORTRANGE("spreadsheet_url","Sheet1!A1:C100")

Practical answers

Frequently asked questions

Use these answers with the dated scope and authoritative sources shown on this page.

What is Google Sheets Shortcuts and Formulas?

First-party keyboard shortcuts and copyable Google Sheets formulas, with browser and operating-system differences noted.

What are the most important points about Google Sheets Shortcuts and Formulas?

Open the in-product shortcut list with Ctrl+/ on Windows/ChromeOS or Cmd+/ on Mac. Some shortcuts vary by browser, keyboard language and operating system. Array formulas can expand into neighbouring cells, so keep the spill range clear.

How should I use this google sheets shortcuts and formulas cheat sheet?

Read the sections on Useful shortcuts, Formula patterns in order, then compare the key points with the documents or figures for your own situation. Do not treat a general example as a substitute for a contract, filing instruction or product-specific rule.

Which jurisdiction and effective date does this page cover?

It covers Global — Google Sheets on computer and is labelled for Google documentation checked 16 November 2026. Rules from another jurisdiction, tax year, product version or contract may produce a different answer.

What should I verify before acting on it?

Confirm exceptions and later changes in the linked material from Google Docs Editors Help. The page was last verified 16 November 2026; provider terms, forms, thresholds, software features and local rules can change after that date.

Authoritative sources

Use the linked source for current instructions and exceptions before acting.

Educational reference only. It is not legal, tax, accounting, lending, insurance or investment advice.