- The Format Painter is available in most of the Microsoft packages and allows the formatting from one part of a document to be repeated elsewhere. If that’s not clever enough then double-clicking on it enables it to be used over and over again.
- In Microsoft Word the Show/Hide icon shows unprintable characters such as when the enter key has been pressed or a page break inserted. It helps you to see what has been going on in the document behind the scenes!!
- Still in Word, turning on the ruler helps you see where tab stops, indents and tables have been applied.
Animationin Microsoft PowerPoint easily allows items such as bullet points to appear one at a time. This makes presenting much more structured.
Flag for Follow Up
- In Microsoft Outlook when you hover near the right side of a message a ghosted flag symbol appears. When you click on this it flags the message to be followed up. This can be searched for or alternatively can show in the
To Dobar if that is switched on. It’s a great way to keep track of what you still need to deal with.
- Autofill in Microsoft Excel enables similar calculations and patterns in numbers, dates and text to be completed by dragging on the cross that appears when you hover over the bottom right of the cell. This is much quicker than filling it in manually or copying and pasting which is the alternative.
- Flash Fill is a new feature available from Excel 2016. If data is entered in a new column and Excel thinks there is a pattern related to existing data then the rest of the column can be completed by pressing enter. It doesn’t always get it right but when it does it is amazing and often prevents the use of formulas which regularly the only alternative.
Excelthe function key F4 fixes the cell when autofillingby putting in dollar signs. This saves a lot of time compared to typing them in manually.
- Another Excel one!! Freeze P
anes keepsheadings fixed at the top or left of the screen but did you know it can also be used to freeze both rows and columns together?
- Final one!! Also in Excel! Print Titles repeats the headings at the top or left of every printed page. This is not something you should try and do manually.
Have a look to see if any of these a tools could be of use.