Number Format and Show Formulas Shortcuts in Excel for Mac (2026)
What toggles formulas and values in Excel for Mac?
Microsoft lists Ctrl+Grave accent to alternate between displaying cell values and displaying cell formulas, and Exceljet lists the same Control plus grave accent key as toggling formulas on and off.
The grave accent key sits left of the number 1 key on a US keyboard. Exceljet says the shortcut works by switching the Show Formulas button on the Formulas tab. We did not open a source for other keyboard layouts, so on a non-US keyboard the key may be elsewhere.
Which number format shortcuts does Microsoft list for Excel for Mac?
Microsoft lists Control with Shift plus a symbol key for each format: ~ General, $ currency, % percentage, ^ exponential, # date, @ time, and ! for number.
| Task | Microsoft (Mac table) | Exceljet |
|---|---|---|
| Show formulas or values | Ctrl+Grave accent | Control+Grave accent |
| General number format | Ctrl+Shift+Tilde | Not opened |
| Currency, two decimals, negatives in red with parentheses | Ctrl+Shift+Dollar sign | Control+Shift+Dollar sign |
| Percentage, no decimals | Ctrl+Shift+Percent sign | Control+Shift+Percent sign |
| Exponential, two decimals | Ctrl+Shift+Caret | Not opened |
| Date with day, month and year | Ctrl+Shift+Number sign | Not opened |
| Time with hour and minute, AM or PM | Ctrl+Shift+At symbol | Not opened |
| Number, two decimals, thousands separator, minus sign | Ctrl+Shift+Exclamation point | Not opened |
Do Cmd or Control work for these?
Microsoft says many Windows Ctrl shortcuts also work with the Control key in Excel for Mac but not all, and every format and formula row in its Mac table uses Ctrl, not Cmd.
Apple's shortcut page, which we read, does not list these Control and Shift symbol combinations as macOS shortcuts. We did not test whether another app or a utility intercepts them. If one does nothing, check System Settings, Keyboard, Keyboard Shortcuts, which is the place Microsoft's page points to for conflicts.
What do the sources say?
Microsoft and Exceljet agree on every shortcut they both list: currency, percent and Show Formulas; Microsoft alone lists the other formats, and neither page is dated.
This is a reference page: the sources do not disagree, so the main risk is a typing slip with symbol keys, which need Shift on most layouts.
Where does Mac Excel Shortcuts fit?
Mac Excel Shortcuts is our app that replicates Windows Excel shortcuts on a Mac. We did not check whether it covers these formats, so see the covered-list page before relying on it.
It has a free trial of 7 days or 10 shortcut uses, then costs $49 once or $4.99 a month. This page is not a test of the app. See the list of shortcuts it covers.
FAQs
What is the shortcut for currency format in Excel for Mac?
Microsoft and Exceljet list Control+Shift+Dollar sign.
How do I show formulas in Excel for Mac?
Microsoft and Exceljet list Control plus the grave accent key to toggle between values and formulas.
Do I use Cmd or Control for number formats on a Mac?
Microsoft's Mac table lists Ctrl with Shift for each number format.
What is the percent format shortcut?
Microsoft and Exceljet list Control+Shift+Percent sign. Microsoft says it applies the percentage format with no decimal places.
Related guides
Mac Excel shortcut cheat sheet: the wider list.
Why Excel keyboard shortcuts do not work on Mac: the conflict checklist.
Excel for Mac vs Windows differences: what else differs.
How we checked this guide
We opened the pages below on November 15, 2026. We read Microsoft's Excel for Mac shortcut table directly from the page and compared it with the other sources. We did not test Excel on a Mac. Limits: Neither Microsoft nor Exceljet shows an edit date; Exceljet was read through its index and one page; keyboard layouts other than US were not checked.
References
Microsoft Support, Keyboard shortcuts in Excel, undated (page footer shows 2026). Mac section read November 15, 2026.
Exceljet, Excel shortcuts, undated. Accessed November 15, 2026.
Apple Support, Mac keyboard shortcuts, published September 14, 2026. Accessed November 15, 2026.
