This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Translate with Excel
Problem: I have a client whose German subsidiary sent me an Excel file. The headings are in German. I need to figure out what each column means.
Strategy: Excel added a translation interface to the Review tab of the ribbon. Although the translations are not perfect, they can give you a general idea of the meaning of a passage or paragraph. Here’s how it works:
1. Select a cell that contains text you want to translate.
2. Select Review, Translate. The Research task pane appears along the right side of the window.
Figure 120 Choose text in a cell and click Translate.
3. In the From dropdown, choose German.
4. In the To dropdown, choose English. In a few moments, a rough translation will appear in the Research pane.
Figure 121 A rough translation will appear.
Additional Details: The Research pane offers a link to Translation Options. The Translation Options dialog allows you to prevent translation between certain languages. If you have a rogue employee who is addicted to ordering Italian shoes on company time, perhaps you would want to turn off the Italian to English language pair. The dialog also allows you to choose the translation service to use for any given language. Choose between Microsoft Translator and WorldLingo.