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
Copilot
Copilot and Dog Tricks
AI technology can be a game-changer in how we interact with our pets. It can analyse patterns in your dog's behavior and suggest new tricks tailored to their learning style.
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.
365 Productivity
How to create a Secondary Axis Chart in Excel
These types of charts let you display to different types of values eg: quantity and percentage. The percentage figures will appear on the secondary axis as a different chart type. Click 'Recommended Charts' to have one created for you.