Alt + H + A + N in Google Sheets (Accounting Number Format)
Applies Excel's accounting format (the $ button on the Home tab) to the selection.
Add to Chrome (14 Days Free)In Excel: Home tab, Number Format. In ShortieCuts' key-tip menu: "Format as Currency".
What Alt + H + A + N Does in Excel
Applies Excel's accounting format (the $ button on the Home tab) to the selection.
How to Use Alt + H + A + N 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, A, then N. ShortieCuts runs Accounting Number Format, just like Excel.
Google Sheets has no separate accounting button, so ShortieCuts applies the Sheets currency format, the closest match.
Built-in Google Sheets alternative: Ctrl + Shift + 4 (Cmd + Shift + 4 on Mac) also applies currency format.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt HN | Number FormatOpens the number format list so you can pick General, Number, Currency, Date and so on. |
| 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 HFM | More Number FormatsOpens the full number format options, where you can write a custom format such as #,##0;(#,##0) for negatives in brackets. |
| 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 + A + N work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + H + A + N won't run Accounting Number Format. With the ShortieCuts Chrome extension installed, Alt + H + A + N works in Google Sheets the same way it does in Excel.
What does Alt + H + A + N do in Excel?
Accounting Number Format. Applies Excel's accounting format (the $ button on the Home tab) to the selection.
How do I use Alt + H + A + N on a Mac?
With ShortieCuts, press Option instead of Alt, then H, then A, then N: Option + H + A + N. The same key-tips appear as on Windows.
Is there a built-in Google Sheets shortcut for Accounting Number Format?
Ctrl + Shift + 4 (Cmd + Shift + 4 on Mac) also applies currency format.
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.