Templates Services SQL Reports Excel Shortcuts Blog About Contact
⌨ Excel Shortcut Guide

Apply percentage format Shortcut in Excel

Use this quick reference to learn the Windows shortcut, Mac shortcut, Ribbon path, and best use case for apply percentage format in Excel.

Shortcut keys

WindowsCtrl + Shift + %
MacCmd + Shift + %

Ribbon path

Home → Number Format → Percentage

What it does

Applies percentage format to the selected cells. Note: 0.5 becomes 50%.

How to use this shortcut

  1. Open the Excel workbook and select the relevant cell, row, column, range, or sheet.
  2. Press the shortcut keys shown above for your platform.
  3. Confirm any dialog options if Excel opens a menu or prompt.

FAQ

What is the Excel shortcut for apply percentage format?

On Windows, use Ctrl + Shift + %. On Mac, use Cmd + Shift + %.

Where is apply percentage format in the Excel Ribbon?

The Ribbon path is Home → Number Format → Percentage.

What does apply percentage format do in Excel?

Applies percentage format to the selected cells. Note: 0.5 becomes 50%.