Excel Shortcuts That Don't Work in Google Sheets (and How To Get Them Back)
The basic copy, paste and formatting keys carry over from Excel to Google Sheets. The keys that make an analyst fast mostly do not: the Alt ribbon, F4 repeat, Ctrl + [ tracing, Ctrl + 9 and Ctrl + 0, one-stroke freeze panes and Goal Seek.
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); 230+ 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 UsersGoogle Sheets has no Goal Seek command. ShortieCuts adds one on the same Alt + A + W + G keys Excel uses, with the same three boxes, so you can backsolve a model in Sheets the way you would in Excel.
- Freeze Panes in Google Sheets for Excel UsersExcel freezes rows and columns together from the selected cell with Alt + W + F + F. Google Sheets makes you set rows and columns separately from the View menu. ShortieCuts restores the one-stroke version.
- Paste Special in Google Sheets for Excel UsersGoogle Sheets has a Paste special menu and two native shortcuts, but none of Excel's Alt + H + V or Alt + E + S sequences. 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 Google Sheets, F4 cycles a reference through its dollar-sign forms while you edit a formula, just as in Excel. Excel's other F4, repeat last action, is missing natively; ShortieCuts brings it back.