Exceljet

Quick, clean, and to the point

Apply percentage format

Windows shortcut 
CtrlShift%
Mac shortcut 
%

Apply the Percentage format with no decimal places.

Related videos

Tip: How to plot survey data in a bar chart
In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for creating an "other" bucket.
I absolutely LUV your explanations and examples! You have saved me a lot of time and frustration. Thank you, thank you, thank you. -Katalin
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course