Microsoft Office Tips, Tricks and Shortcuts

Use range names to create meaningful Excel formulas

July 19, 2012 Liz Todd

Understanding what formulas actually show can be a challenge particularly if you are working with an Excel workbook that someone else has created. Formulas that use range names rather that cell references are much easier to understand. For example, =Income–Expenses is much more meaningful than =D9 D25. Creating range names is really easy! Simply select the cell or cells that you want to name, click the Name Box at the left of the Formula bar, type the name (eg Sales) and tap Enter. A few pointers: you’ll find the Name Box above column A; range names can’t include spaces or...

Clean up the formatting in a Word document

June 26, 2012 Liz Todd

Have you ever tried to copy and paste text from a colleague’s document into your own Word document with the result that the formatting of the pasted text changes beyond recognition? If so, these tips are for you! Strip the text of its existing formatting Before bringing someone else’s text into your document, it is a good idea to paste the text in a new blank document and strip it of the formatting that the other user has applied. There are two shortcut keys that can help you with this: Ctrl+Spacebar and Ctrl+Q. Ctrl+Spacebar removes any character formats – bold,...

Managing email addresses in Outlook

March 30, 2012 Liz Todd

Email addresses are now as common as phone numbers. It is essential to have email addresses available when you need them and be able to enter them without typing the entire address. Microsoft Outlook makes it easy for you to re-use email addresses from messages that you send and receive. How do I save an email address in an email message into Outlook Contacts? Open or preview the message that has the email address that you want to add to Contacts, right click the email address and then click Add to Outlook Contacts. I really like the list of email...