Guides
How to do the Excel things you rely on in Google Sheets, with and without ShortieCuts.
- 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.
- 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.
- 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.
- Every Excel ALT Shortcut in Google SheetsThe full list of key sequences ShortieCuts supports.