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 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!
365 Productivity
Dictation in Outlook
With just a simple tap, your spoken words are converted into text, making email creation on both desktop and mobile devices faster and more accessible than ever.
365 Productivity
Word Tip - Select Text with Similar Formatting
A quick fix for a formatting change.
Don't bother with the format painter - next time go to the Home Ribbon > Editing > Select > Select Text with Similar Formatting.
Then make your changes - Presto!, All similar text will also be updated throughout the document.