Microsoft Office

Archive: 06-2012

• Word: How to format just the numbers in a numbered list

  Formatting a list is easy. Formatting just the numbers is more difficult, unless you know this quick trick!

  Posted by Susan Harkins | June 27, 2012, 3:22 AM PDT

• Three ways to control Excel's cursor movement during data entry

  Inputting data is seldom anybody’s favorite chore but controlling the way the cursor moves certainly eases the task.

  Posted by Susan Harkins | June 26, 2012, 8:14 AM PDT

• Quick tip: Find Excel's XLStart folder fast

  We seldom need the XLStart folder, so when we do, we can never remember the entire path. Instead of searching, use this quick Excel tip instead.

  Posted by Susan Harkins | June 25, 2012, 1:01 PM PDT

• Three ways to hide zero values in an Excel sheet

  Although zero values are valid, you might need to hide them. Here are three methods for hiding zero values in an Excel sheet.

  Posted by Susan Harkins | June 21, 2012, 8:18 AM PDT

• An alternative Excel averaging formula that doesn't evaluate zero

  Excel’s AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives.

  Posted by Susan Harkins | June 20, 2012, 11:49 AM PDT

• Tweak an annoying AutoCorrect entry instead of deleting it outright

  You can delete a problematic AutoCorrect entry or you can try this case shuffling trick to have your cake and eat it too.

  Posted by Susan Harkins | June 19, 2012, 8:48 AM PDT

• Quickly delete whole paragraphs by searching styles

  Using styles often has unexpected perks. For instance, you can delete multiple paragraphs by relying on a style.

  Posted by Susan Harkins | June 14, 2012, 7:07 AM PDT

• Outlook's conversation settings lead to a more efficient Inbox

  Use Outlook’s conversation view to arrange related messages into meaningful groups.

  Posted by Susan Harkins | June 12, 2012, 12:20 PM PDT

• A quick Excel keyboard trick for selecting large ranges

  You’ll want to add this quick selection trick to your repertoire. It’s handy when the range isn’t a complete data range or it comprises more than one data range.

  Posted by Susan Harkins | June 11, 2012, 10:53 AM PDT

• Slicers provide a quick way to filter an Excel pivot table

  Filtering a pivot table isn’t hard, but Excel 2010 slicers make it even easier.

  Posted by Susan Harkins | June 7, 2012, 7:56 AM PDT