Microsoft Office

Archive: 07-2012

• Use Word's Go To feature to browse common elements

  Word’s Go To feature has two modes of navigation. You can use it to access an element once, or you can browse common elements, one by one.

  Posted by Susan Harkins | July 26, 2012, 7:46 AM PDT

• Display the total number of emails in an Outlook folder

  To the right of each mail folder, Outlook displays the number of unread messages. With a few clicks, you can change that number to the number of total messages in the folder instead.

  Posted by Susan Harkins | July 25, 2012, 9:57 AM PDT

• A quick way to return the latest date in a subset in Excel

  Identifying the latest entry for a subset doesn’t have to be difficult - use a pivot table.

  Posted by Susan Harkins | July 24, 2012, 8:26 AM PDT

• Grant yourself access to Word's horizontal and vertical rulers

  Word’s ruler is a bit unpredictable - now you see it, now you don’t. Learn how to control its seemingly unruly behavior.

  Posted by Susan Harkins | July 20, 2012, 11:22 AM PDT

• Modify a style at the template level

  You can modify a style on two levels: for the current document only or for all new documents based on the underlying template. Make sure you make the right choice.

  Posted by Susan Harkins | July 19, 2012, 11:13 AM PDT

• Sum only negative values in a given range using SUMIF()

  Summing only the positive or negative values in the same range of values only sounds difficult. Fortunately, the SUMIF() function can handle both.

  Posted by Susan Harkins | July 17, 2012, 8:10 AM PDT

• A quick way to create a list of sequential numbers in Word

  Creating a list of sequential numbers isn’t as difficult as it might sound at first. If you can create a table, you can create a list of sequential numbers.

  Posted by Susan Harkins | July 12, 2012, 7:43 AM PDT

• Two useful Word shortcuts for quickly deleting text

  Editing text is tedious work. Use these two shortcuts to delete whole words instead of single characters.

  Posted by Susan Harkins | July 11, 2012, 9:02 AM PDT

• Automatically start an Office program when you turn on your computer

  If you begin your workday in the same Office app every day, let Windows start that app for you.

  Posted by Susan Harkins | July 9, 2012, 11:35 AM PDT

• The right way to create a Word template

  Sometimes it’s tempting to take shortcuts, but fight the urge when creating a new Word template.

  Posted by Susan Harkins | July 5, 2012, 2:33 AM PDT