200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Format cell value with percentage formatting

This shortcut changes the format within all selected cells to a percentage-based format. When used shortcut will add a percentage sign and two zeros to any numbers within your selection. (I.E. 20000%)


Ctrl Shift %

Control Shift %

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.