Excel - Percentages
It's simple when you know how! And to incorporate shortcuts into your Excel formulas, means you just get things done even more quickly.
Ctrl + = for Autosum
F4 to lock a cell in to make it an absolute cell reference
Ctrl + Shift + 5 to make a number format into a percent
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
365 Productivity
How to Format Slicers in Excel
Slicers are a winning feature in Excel - Slice and Dice data in a simple and user-friendly interface
365 Productivity
How to add percentage labels to a pie chart
Your Pie Chart in Excel comes ready with percentage labels - you just need to know where to find them!
How to sort dates in your Power BI report.
Display the dates correctly in your Power BI reports and dashboards.