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 HabitWhat It Does in ExcelPlain Google SheetsWith ShortieCuts
Alt + letters (e.g. Alt + H + V + V)Runs ribbon commands by key-tipNo ribbon and no key-tipsKey-tips appear on Alt (Option on Mac); 230+ Excel sequences
F4 while editing a formulaCycles $ referencesWorks the same wayLeft as Sheets handles it
F4 when not editingRepeats the last actionNo repeat-last-action keyRepeats the last ShortieCuts command
Ctrl + [Trace precedentsNo trace commandSelects the cells the formula refers to, including other tabs
Ctrl + ]Trace dependentsNo trace commandFinds formulas that refer to the cell, current sheet first, then all sheets
F5 after tracingGo To, back to where you startedNo Go To dialogOpens a Traces list to jump back
Ctrl + 9 / Ctrl + 0Hide rows / hide columnsNot Excel's behaviorHides rows / hides columns
Ctrl + - / Ctrl + Shift + =Delete / insert cells, rows or columnsNot Excel's behaviorDelete / insert, Excel style (Windows)
Ctrl + 5StrikethroughNot Excel's behaviorStrikethrough
Alt + W + F + FFreeze panes at the active cellView > Freeze, rows and columns set separatelyFreezes rows above and columns left in one stroke
Alt + A + W + GGoal SeekNo built-in Goal SeekGoal 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