Microsoft Office Productivity

Merged cells can play havoc with the normal functioning of some of Excel’s tools. There may be times that you need to identify merged cells in a worksheet before performing certain functions. Using the “Find” feature, you can quickly identify any merged cells. This process will work the same in Excel 2003, Excel 2007 and Excel 2010.

If you have a worksheet that requires that a column or row only contain numeric values, you can limit the entry in the cell using Data Validation. This will prevent anyone from entering text or dates or any other type of data other than a number.

In Microsoft Word 2007 you can translate a word, phrase or entired document into another language.  This video will show you how to use this feature in Word 2007.

Using Microsoft Word 2010 you can translate a word, phrase or entire document into another language.  This tutorial will show you how to use this feature in Word 2010 only.