Excel Shortcuts That Don't Work in Google Sheets (and How To Get Them Back)
ShortieCuts brings back the Excel keys that stop working in Google Sheets: the Alt ribbon Key Tips, F4 repeat, Ctrl + [ tracing, Ctrl + 9 and Ctrl + 0, one-stroke freeze panes and Goal Seek. The basic copy, paste and formatting keys carry over on their own.
What Carries Over and What Doesn't
If you learned spreadsheets in Excel, your first day in Google Sheets feels fine. Copy, paste, undo, bold, italic, underline and moving around with Ctrl + arrow keys all behave the way you expect. The friction shows up an hour later, when you reach for the keys that make an analyst quick: the ribbon sequences, the auditing keys, the one-stroke layout commands. Those are the ones that do nothing, or something different.
The reason is structural. Many of Excel's power shortcuts are not standalone shortcuts at all. They are paths through the ribbon, triggered by pressing Alt and reading the key-tip letters. Google Sheets has menus, not a ribbon, so that whole layer is missing. Other gaps are features Sheets simply does not have, such as tracing and Goal Seek.
Excel Habits vs Google Sheets: The Comparison
| Excel Habit | What It Does in Excel | Plain Google Sheets | With ShortieCuts |
|---|---|---|---|
| Alt + letters (e.g. Alt + H + V + V) | Runs ribbon commands by key-tip | No ribbon and no key-tips | Key-tips appear on Alt (Option on Mac); 233 Excel sequences |
| F4 while editing a formula | Cycles $ references | Works the same way | Left as Sheets handles it |
| F4 when not editing | Repeats the last action | No repeat-last-action key | Repeats the last ShortieCuts command |
| Ctrl + [ | Trace precedents | No trace command | Selects the cells the formula refers to, including other tabs |
| Ctrl + ] | Trace dependents | No trace command | Finds formulas that refer to the cell, current sheet first, then all sheets |
| F5 after tracing | Go To, back to where you started | No Go To dialog | Opens a Traces list to jump back |
| Ctrl + 9 / Ctrl + 0 | Hide rows / hide columns | Not Excel's behavior | Hides rows / hides columns |
| Ctrl + - / Ctrl + Shift + = | Delete / insert cells, rows or columns | Not Excel's behavior | Delete / insert, Excel style (Windows) |
| Ctrl + 5 | Strikethrough | Not Excel's behavior | Strikethrough |
| Alt + W + F + F | Freeze panes at the active cell | View > Freeze, rows and columns set separately | Freezes rows above and columns left in one stroke |
| Alt + A + W + G | Goal Seek | No built-in Goal Seek | Goal Seek dialog with Excel's three boxes |
The Alt Ribbon Key-Tips
This is the biggest loss, because it covers hundreds of commands. Formatting a model in Excel is mostly Alt + H sequences: borders, number formats, fills, alignment, column widths. In Sheets the same work means hunting through toolbar icons and nested menus.
With ShortieCuts installed, pressing Alt (Option on a Mac) shows Excel-style key-tips over Google Sheets, and you type the letters you already know. Alt + H + B + B puts a double bottom border under a total, Alt + H + K applies comma style, Alt + H + V + V pastes values, and Alt + H + O + I autofits column width. If the key-tips get in your way, F10 cycles how they are shown.
F4: Half of It Works
Excel gives F4 two jobs. While you edit a formula, it cycles a reference between A1, $A$1, A$1 and $A1. Google Sheets supports that part natively. Outside of editing, Excel's F4 repeats your last action, which is how most people apply the same border or insert the same row ten times in a row. Sheets has no equivalent.
ShortieCuts splits the key the same way Excel does. While you are editing a cell, F4 behaves exactly as Sheets normally does. When you are not editing, F4 repeats the last ShortieCuts command. Run Alt + H + I + R once to insert a row, then move and press F4 to insert another.
Ctrl + [ and Ctrl + ]: Formula Tracing
Google Sheets has no Trace Precedents or Trace Dependents command. For anyone who reviews models, that is the most painful gap: you cannot jump from a number to its inputs, or check what breaks before you delete a row.
ShortieCuts adds both on Excel's keys. Ctrl + [ selects the cells the active formula refers to, and follows references onto other tabs. Ctrl + ] finds the cells whose formulas refer to the active cell, searching the current sheet first and then all sheets if nothing turns up. F5 opens a Traces list so you can return to where you started. On a Mac the trace keys use Control. Tracing is a Pro feature, included in the 14-day free trial. The tracing guide walks through it.
Hide, Delete, Insert and Strikethrough
The Ctrl + number keys are small habits that add up. With ShortieCuts, Ctrl + 9 hides rows and Ctrl + 0 hides columns, matching Alt + H + O + U + R and Alt + H + O + U + C. Ctrl + 5 applies strikethrough, Ctrl + 7 cycles cell borders, and on Windows Ctrl + - deletes while Ctrl + Shift + = inserts, as in Excel. For a dialog-driven delete, Alt + H + D + D shows an Excel-style Delete dialog inside Sheets.
Freeze Panes in One Stroke
In Excel you click the cell below and to the right of what you want locked and press Alt + W + F + F. In Sheets you go to View > Freeze and set rows and columns as two separate choices. ShortieCuts restores the one-stroke version: Alt + W + F + F freezes the rows above and columns to the left of the selected cell, and pressing it again when both are frozen unfreezes them. Alt + W + F + R and Alt + W + F + C freeze just the top row or first column.
Goal Seek
Sheets has no built-in Goal Seek. Google offers a separate add-on, but it does not respond to Alt + A + W + G. ShortieCuts opens a Goal Seek dialog on those keys with Set cell, To value and By changing cell, plus options for time limit, tolerance and iterations. Esc cancels a search that runs long.
Paste Special
Sheets does have native paste shortcuts: Ctrl + Shift + V pastes values only and Ctrl + Alt + V pastes format only (Cmd + Shift + V and Cmd + Option + V on a Mac). The Excel sequences do not exist. ShortieCuts adds Alt + H + V + F for formulas, Alt + H + V + T for transpose and the classic Alt + E + S + V family. Alt + H + V + B pastes everything except borders, which matters when you copy into a model that already has its own border scheme.
Getting Started
ShortieCuts runs in Chrome. Install it, open any Google Sheet and press Alt to see the key-tips. The shortcuts index lists every supported sequence. For more on retraining your hands, see Excel shortcuts for Google Sheets and ALT-key shortcuts for Google Sheets. Pro is $7.99 a month or $69.99 a year with a 14-day free trial and no credit card required; see pricing.
FAQ
Why don't Excel Alt shortcuts work in Google Sheets?
Excel's Alt sequences drive the ribbon through key-tips, and Google Sheets has no ribbon or key-tips. ShortieCuts adds an Excel-style key-tip layer: press Alt (Option on a Mac) and type the same letters as in Excel.
Does F4 work in Google Sheets?
While you are editing a formula, yes: F4 cycles a reference through its dollar-sign forms, as in Excel. Excel's other use of F4, repeating the last action, has no native equivalent. With ShortieCuts, F4 outside of editing repeats the last ShortieCuts command.
Can I trace precedents and dependents in Google Sheets?
Not natively. Google Sheets has no Trace Precedents or Trace Dependents command. ShortieCuts adds them on Ctrl + [ and Ctrl + ] (Control on a Mac) as a Pro feature included in the 14-day free trial.
Do the Excel shortcuts work on a Mac?
Yes. Use Option where Excel on Windows uses Alt to bring up the key-tips, and the Control key for the trace shortcuts.
More Guides
- Trace Precedents and Dependents in Google SheetsCtrl + [ and Ctrl + ], step by step, plus native workarounds.
- Alt + H + O + I in Google SheetsAutoFit column width the Excel way.
- Goal Seek in Google Sheets for Excel UsersIn ShortieCuts, Alt + A + W + G opens Goal Seek in Google Sheets with the same three boxes as Excel, so you can backsolve a model the way you would in Excel. Google Sheets has no Goal Seek command of its own.
- Freeze Panes in Google Sheets for Excel UsersIn ShortieCuts, Alt + W + F + F freezes rows and columns together from the selected cell in Google Sheets, just as in Excel. Without it, Google Sheets makes you set rows and columns separately from the View menu.
- Paste Special in Google Sheets for Excel UsersIn ShortieCuts, Alt + E + S + V pastes values in Google Sheets, along with the rest of Excel's Alt + H + V and Alt + E + S sequences. Google Sheets itself has a Paste special menu and two native shortcuts; here is the full key map, the one shortcut that means something different, and what Sheets cannot do at all.
- F4 and Absolute References in Google SheetsIn ShortieCuts, F4 repeats the last ShortieCuts command in Google Sheets when you are not editing a cell, just as in Excel. While you edit a formula, Google Sheets already cycles a reference through its dollar-sign forms with F4, so that part needs no extension.