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.

TaskMicrosoft (Mac table)Exceljet
Show formulas or valuesCtrl+Grave accentControl+Grave accent
General number formatCtrl+Shift+TildeNot opened
Currency, two decimals, negatives in red with parenthesesCtrl+Shift+Dollar signControl+Shift+Dollar sign
Percentage, no decimalsCtrl+Shift+Percent signControl+Shift+Percent sign
Exponential, two decimalsCtrl+Shift+CaretNot opened
Date with day, month and yearCtrl+Shift+Number signNot opened
Time with hour and minute, AM or PMCtrl+Shift+At symbolNot opened
Number, two decimals, thousands separator, minus signCtrl+Shift+Exclamation pointNot 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.

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

← Back to all articles

Mac Excel Shortcuts: Excel shortcuts not working on Mac? Alt E S V, Paste Values, the Windows way. Try it free for 7 days.