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
| Action | Windows / ChromeOS | Mac |
|---|---|---|
| Shortcut list | Ctrl+/ | Cmd+/ |
| Tool finder | Alt+/ | Option+/ |
| Paste values only | Ctrl+Shift+V | Cmd+Shift+V |
| Select column | Ctrl+Space | Ctrl+Space |
| Select row | Shift+Space | Shift+Space |
| Fill down | Ctrl+D | Cmd+D |
| Insert date | Ctrl+; | Cmd+; |
| Show formulas | Ctrl+~ | Ctrl+~ |
| Insert new sheet | Shift+F11 | Shift+F11 |
Formula patterns
| Task | Formula |
|---|---|
| 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.
- Keyboard shortcuts for Google SheetsGoogle Docs Editors Help
- Add formulas and functions in Google SheetsGoogle Docs Editors Help
Educational reference only. It is not legal, tax, accounting, lending, insurance or investment advice.
