Alt + M + H in Google Sheets (Show Formulas)
Switches the sheet between showing formula results and showing the formulas themselves.
Add to Chrome (14 Days Free)In Excel: Formulas tab, Formulas. In ShortieCuts' key-tip menu: "Show Formulas".
What Alt + M + H Does in Excel
Switches the sheet between showing formula results and showing the formulas themselves.
How to Use Alt + M + H in Google Sheets
- Add the ShortieCuts extension to Chrome and open any Google Sheet.
- Select the cells you want to work on (if the command needs a selection).
- Press Alt (or Option on Mac). Excel-style key-tips appear over the sheet.
- Press M, then H. ShortieCuts runs Show Formulas, just like Excel.
Built-in Google Sheets alternative: Ctrl + ` (Cmd + ` on Mac) also toggles formula view.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt MF | Insert FunctionOpens the function picker so you can find and insert a function. |
| Alt MN | Name ManagerOpens the list of named ranges in the workbook. |
| Alt MMD | Define NameLets you give the selected range a name you can use in formulas. |
| Alt MI | Financial FunctionsOpens the list of financial functions, such as NPV, IRR, PMT and XIRR. |
| Alt ML | Logical FunctionsOpens the list of logical functions, such as IF, AND, OR and IFERROR. |
| Alt MT | Text FunctionsOpens the list of text functions, such as LEFT, MID, TRIM and TEXT. |
| Alt ME | Date & Time FunctionsOpens the list of date and time functions, such as EOMONTH, EDATE and NETWORKDAYS. |
| Alt MO | Lookup & Reference FunctionsOpens the list of lookup functions, such as VLOOKUP, INDEX, MATCH and XLOOKUP. |
FAQ
Does Alt + M + H work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + M + H won't run Show Formulas. With the ShortieCuts Chrome extension installed, Alt + M + H works in Google Sheets the same way it does in Excel.
What does Alt + M + H do in Excel?
Show Formulas. Switches the sheet between showing formula results and showing the formulas themselves.
How do I use Alt + M + H on a Mac?
With ShortieCuts, press Option instead of Alt, then M, then H: Option + M + H. The same key-tips appear as on Windows.
Is there a built-in Google Sheets shortcut for Show Formulas?
Ctrl + ` (Cmd + ` on Mac) also toggles formula view.
Is ShortieCuts free?
ShortieCuts has a free 14-day trial with no credit card needed. After the trial, Pro is $7.99 a month or $69.99 a year.