Google Sheets Formula & Data Shortcuts
Sheets shares its fundamental formula-editing shortcuts with Excel, but layers on a set of genuinely browser-native, collaboration-aware data tools that don't map to anything in Excel at all — Explore's auto-generated analysis, and the tight integration between filters, data validation, and named ranges that matters far more in a spreadsheet several people are actively editing at once than in a typical single-author Excel workbook.
| Action | Windows | Mac | Description |
|---|---|---|---|
| Insert SUM formula (AutoSum) | Alt+= | Cmd+Shift+= | Adds a SUM formula with its best-guess range of adjacent cells already filled in, using the identical key Excel binds on Windows, though Excel on Mac maps this to Shift+Cmd+T instead. |
| Toggle formula view | Ctrl+` | Cmd+` | Switches the sheet to display formula text instead of calculated results, identical in purpose and key combination to Excel's equivalent shortcut. |
| Toggle absolute/relative reference | F4 (while editing a formula) | Cmd+T or Fn+F4 | Cycles a cell reference through absolute and relative states while editing a formula, matching Excel's behavior closely though Sheets' F4 cycling order can differ slightly by locale and version. |
| Fill down | Ctrl+D | Cmd+D | Fills the selection downward from its top row, identical behavior and key combination to Excel's Ctrl+D. |
| Open Data Validation dialog | Data menu > Data validation (no default global key) | — | Opens the dialog for restricting what values can be entered into a cell or range, like a dropdown list of approved options, commonly used to keep a shared operational spreadsheet's data consistent across many contributors. |
| Define a named range | Data menu > Named ranges (no default global key) | — | Assigns a readable name to a specific cell range, letting formulas reference that name instead of a raw range address, improving formula readability especially in a heavily shared, collaboratively edited spreadsheet. |
| Open Explore panel | Ctrl+Alt+Shift+X | Cmd+Option+Shift+X | Opens Sheets' Explore sidebar, which auto-generates suggested charts, pivot tables, and summary statistics based on the selected data, a feature with no direct Excel equivalent bound to a keyboard shortcut in the same way. |
| Create a filter | Ctrl+Shift+L | Cmd+Shift+L | Turns on filter controls across the header row of the selected range, letting anyone viewing the sheet narrow visible rows by column value — distinct from a Filter View, which is a saved, personal filtering configuration that doesn't change what collaborators see. |
AutoSum (Alt+= on Windows, Cmd+Shift+= on Mac) drops in a SUM formula with a best-guess range, functioning identically to Excel's version on Windows, though the Mac binding differs from Excel's Shift+Cmd+T — simply two companies choosing different Mac-specific key combinations independently rather than any deeper technical reason. As in Excel, it's worth glancing at the highlighted guessed range before confirming, since AutoSum's guess stops at the first blank or non-numeric cell it encounters and won't always span your entire intended dataset.
Toggle formula view (Ctrl+` on both platforms) switches the whole sheet between calculated results and raw formula text, identical in purpose and key combination to Excel, and just as useful for auditing an entire model at a glance for hardcoded values or copy-paste mistakes hiding among what should be consistent formulas.
F4, while editing a formula, cycles a cell reference through absolute and relative states — again matching Excel's core behavior, though Sheets' exact cycling order and Mac binding (Cmd+T, or Fn+F4) can vary slightly depending on your locale and Sheets version, so it's worth a one-time check on your specific setup rather than assuming it's pixel-identical to Excel's.
Ctrl+D (fill down) works identically to Excel: select a range starting with the source cell and ending at the bottom of your intended fill area, and Sheets fills every cell with the source's content, adjusting relative references exactly as if dragged with the fill handle.
Data validation (Data menu > Data validation) restricts what values a cell or range can accept — commonly a dropdown of approved options — and matters disproportionately in Sheets compared to a typical single-author Excel file, since a shared operational spreadsheet edited by many people with varying spreadsheet fluency benefits enormously from constraining what can be typed into a given field, catching typos and inconsistent entries before they ever make it into the data.
Named ranges (Data menu > Named ranges) assign a readable name to a specific cell range so formulas can reference that name instead of a raw address like B2:B47 — again, this matters more in a heavily shared spreadsheet where formula readability affects several different people's ability to understand and safely edit a model, rather than just the original author's own memory of what a given range contains.
The Explore panel (Ctrl+Alt+Shift+X) is genuinely Sheets-specific: it analyzes whatever data range is currently selected and automatically proposes relevant charts, pivot table layouts, and summary statistics, functioning as a fast, AI-assisted starting point for data analysis that has no precise one-to-one equivalent bound to a single keyboard shortcut in Excel, even though Excel's own separate Ideas/Analyze Data feature serves a broadly similar purpose through its own interface.
Creating a filter (Ctrl+Shift+L) turns on filter controls across a range's header row so any collaborator viewing the sheet can narrow visible rows by column value — worth distinguishing clearly from a Filter View (built separately through the Data menu), which creates a personal, saved filter configuration that only changes what you see, without affecting what other collaborators viewing the same sheet see at the same time. A shared spreadsheet where several people need different filtered views simultaneously depends specifically on Filter Views rather than a single shared filter, since a regular filter's visibility changes are visible to everyone looking at the sheet at once.