Useful MS Office function key shortcuts
These work in all the MS Office programs: F4 – Repeat the last command. Useful if you are doing repetitive formatting in a file F7 – Run the Spellcheck F12 …
How to display 000123 in Excel when you enter 123
Ever had the situation in Excel where you want a number that has leading zeros? So when you enter 123 you want to see 000123 displayed in the cell. One …
A quick way to change the font size in Word, Excel, Outlook and PowerPoint
When working in Word, Excel, Outlook and PowerPoint, I find I often want to increase or decrease the font size of some of the text by a size or two. …
How to bypass Cloud options when opening or saving a file in MS Office
In my experience, most organizations are still storing files on network drives rather than in the Cloud. In recent versions of Word, Excel and PowerPoint, Microsoft has made the Cloud …
How to switch off the Start Screen in Work, Excel and PowerPoint
In the later versions of Word, Excel and PowerPoint, Microsoft implemented a Start Screen which is displayed when you launch the program. The Start Screen has a list of recently …
Keyboard shortcut to turn Filter on or off in Excel
Looking for a quick way to turn Filter on or off in Excel? Try Ctrl+Shift+L. This shortcut is a toggle so if Filter is on it switches it off and …
What’s the quickest way to copy a worksheet in Excel?
What’s the quickest way to copy a worksheet in Excel? Most people Right-click on the worksheet tab then select Move or Copy. That works but there is a quicker way. …
How do you remove number formatting in Excel?
If you work with Excel you will likely have discovered that you can easily format numbers in your spreadsheet. In the middle of the Home tab, there’s a Number group …
Use AutoCorrect to easily fix your common typos
AutoCorrect is a useful feature as it can fix common spelling and typing mistakes. It’s AutoCorrect that replaces hte with the and probelm with problem. What’s really handy about AutoCorrect …
How do you find out which colour is being used for a Font or Fill?
Sometimes I want to use a font or fill colour that is already in use in a document in other places in the document, so I want to find out …