Microsoft Office

Archive: 01-2012

• Add space between table cells in Word to add visual interest

  Learn two easy ways to add visual interest to your Word tables by adding space between cells.

  Posted by Susan Harkins | January 31, 2012, 8:39 AM PST

• Disable send and receive mail options in Outlook

  Users don’t have to both send and receive email via Outlook; they can choose to do one or the other.

  Posted by Susan Harkins | January 30, 2012, 7:59 AM PST

• Quickly highlight matching values in Excel with keyboard shortcut

  When you just need to see matching values and you don’t want to filter or sort, try this Excel keyboard trick.

  Posted by Susan Harkins | January 27, 2012, 6:42 AM PST

• Office solution: How to continue numbering from one table column to another

  This week, learn the solution to the challenge: Can you continue numbering by column? Hint: It’s not intuitive.

  Posted by Susan Harkins | January 26, 2012, 2:02 PM PST

• Office challenge: What's the easiest way to select a specific cell when you return to a specific sheet?

  In this week’s challenge, help a user preserve the cursor location in a sheet whenever he/she returns to it.

  Posted by Susan Harkins | January 25, 2012, 12:28 PM PST

• A quick tip for entering names into an expression

  Show users this quick tip for entering range names into formulas and functions. It’s easy to use and reduces errors from typos.

  Posted by Susan Harkins | January 25, 2012, 12:27 PM PST

• What to do when Excel's Custom Views option is disabled

  Custom views are handy if users need to view data in different ways, but sometimes it isn’t available. Learn why and what to do when this feature is disabled.

  Posted by Susan Harkins | January 24, 2012, 8:27 AM PST

• Office solution: Two ways to eliminate Excel grid lines from a PowerPoint slide

  This week, learn the solution to the earlier challenge, how would you eliminate Excel grid lines from a PowerPoint slide?

  Posted by Susan Harkins | January 19, 2012, 10:52 AM PST

• Three things you must do when you inherit an Excel workbook

  When you inherit a workbook, don’t put it into play without checking it out first with these three vital steps.

  Posted by Susan Harkins | January 19, 2012, 10:49 AM PST

• Use Access validation rules to ensure accurate data entry

  Your Access database is only as sound as the data it stores. Data types can only do so much. The next step is to constrain input values using validation rules.

  Posted by Susan Harkins | January 18, 2012, 8:02 AM PST