Skip to content

↑↓ moveEnter openEsc close

Apply the Percentage format with no decimal places in Excel

Excel Microsoft 365 · 119 shortcuts · checked Nov 2026 · Source: Microsoft docs

In Microsoft Excel, press Ctrl+Shift+5 on Mac, Windows.

What else uses Ctrl+Shift+5?

More Excel shortcuts: format cells

ActionMacWindows
Open the Format Cells dialogCmd1Ctrl1
Apply the General number formatCtrlShift`CtrlShift`
Apply the Currency format with two decimal placesCtrlShift4CtrlShift4
Apply the Scientific number format with two decimal placesCtrlShift6CtrlShift6
Apply the Date format with day, month and yearCtrlShift3CtrlShift3
Apply the Time format with hour, minute and AM or PMCtrlShift2CtrlShift2
Apply the Number format with two decimal places, thousands separator and minus signCtrlShift1CtrlShift1
Apply an outline border to the selected cellsOptionCmd0CtrlShift7
Remove the outline border from the selected cellsOptionCmd-CtrlShift-
Switch between hiding objects, displaying objects and displaying placeholdersCtrl6Ctrl6

All 16 in format cells · All 119 Excel shortcuts