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.