In Excel, while working with data, many times you want to show the data output/results in percentage format instead of showing in number format and you can do this by applying the percentage format to the range of cells where you want to show the numbers in a percentage format.
Users can apply the percentage format manually or very quickly using the keyboard shortcut and, in this tutorial, we have explained the keyboard shortcut to apply the percentage format.
Keyboard Shortcut to Apply Percentage Format in the Excel
The keyboard shortcut to apply the percentage format is mentioned below:
Ctrl + Shift + %
Steps to Apply Percentage Format Using Keyboard Shortcut
- First, select the cells, column(s), or the range of cells, where you want to apply the percentage format.
- Once selected, simply press the “Ctrl + Shift + %” Keys together and your number format values will get converted to percentage format.
More Shortcuts
- Align Center (Excel Shortcut)
- Check Mark (Excel Shortcut)
- Percentage Format (Excel Shortcut)
- Strikethrough (Excel Shortcut)
- Subscript (Excel Shortcut)
- Superscript (Excel Shortcut)
- Apply Date Format (Excel Shortcut)
- Apply Time Format (Excel Shortcut)
⇠ Back to Excel Shortcut Keys (PDF Cheat Sheet)