Alt + H + F + M in Google Sheets (More Number Formats)
Opens the full number format options, where you can write a custom format such as #,##0;(#,##0) for negatives in brackets.
Add to Chrome (14 Days Free)In Excel: Home tab, Number Format. In ShortieCuts' key-tip menu: "Custom Number Format".
What Alt + H + F + M Does in Excel
Opens the full number format options, where you can write a custom format such as #,##0;(#,##0) for negatives in brackets.
How to Use Alt + H + F + M 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 H, F, then M. ShortieCuts runs More Number Formats, just like Excel.
ShortieCuts opens Google Sheets' Custom Number Format dialog.
Without an extension: Google Sheets doesn't support Excel's Alt key-tips, so Alt + H + F + M won't run More Number Formats on its own.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt HN | Number FormatOpens the number format list so you can pick General, Number, Currency, Date and so on. |
| Alt HAN | Accounting Number FormatApplies Excel's accounting format (the $ button on the Home tab) to the selection. |
| Alt HP | Percent StyleFormats the selected cells as percentages. |
| Alt HK | Comma StyleApplies comma style: thousands separators with two decimals, the default for financial tables. |
| Alt H0 | Increase DecimalShows one more decimal place in the selected cells. |
| Alt H9 | Decrease DecimalShows one fewer decimal place in the selected cells. |
| Alt HVV | Paste ValuesPastes only the values of the copied cells. |
| Alt HVF | Paste FormulasPastes the copied formulas without bringing over the source cells' formatting. |
FAQ
Does Alt + H + F + M work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + H + F + M won't run More Number Formats. With the ShortieCuts Chrome extension installed, Alt + H + F + M works in Google Sheets the same way it does in Excel.
What does Alt + H + F + M do in Excel?
More Number Formats. Opens the full number format options, where you can write a custom format such as #,##0;(#,##0) for negatives in brackets.
How do I use Alt + H + F + M on a Mac?
With ShortieCuts, press Option instead of Alt, then H, then F, then M: Option + H + F + M. The same key-tips appear as on Windows.
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.