Microsoft Office Tips and Tricks

Microsoft Access

Here are a few hints to make your data entry quicker and easier:

To remove formatting and contents from a cell, use the Edit, Clear, All command from the menu bar. The Delete key only deletes contents.
To view all the formulas in your worksheet, rather than the results, use the Tools, Options menu command and tick the Formulas option from the View tab.

To automatically create a Word letter addressed to a contact in your contact list: click on the contact and select Actions, New Letter to Contact.
To have any items sitting in your Deleted Items folder automatically deleted when you close Outlook, select the Tools, Options menu command and from the Other tab, tick the Empty the Deleted Items folder upon exiting option.

To make a global change to all your slides, select the View, Master, Slide Master command, and make the required change (e.g. If you need to change the font colour of the title on each slide, once in the Slide Master, select the title placeholder text box at the top of the slide and select the required font colour). Return to your Normal View through the View menu and check all your slides.
If you wish to export your presentation to Microsoft Word in various layouts, select File, Send To, Microsoft Word from the menu bar. Note that in the dialog box there is an option to Paste Link so that if your PowerPoint presentation changes, so will your Word document.

If you wish to select (highlight) various blocks of text e.g. to underline various words and phrases in your documents, simply select the first block as normal and hold down the Ctrl key whilst dragging over the other blocks of text. You can then apply the required formatting.
To move quickly to the end of a document, use the keyboard combination Ctrl-End.