How to translate emails, documents, and more with Microsoft Office (2024)

How-To

Here’s how to translate text from one language to another in Outlook, Word, and Excel — and how to transform spoken words into real-time captions in another language with PowerPoint.

By Lance Whitney

Computerworld |

How to translate emails, documents, and more with Microsoft Office (2)
Table of Contents
  • Translate in Microsoft Outlook on the desktop
  • Translate in Microsoft Outlook on the web
  • Translate in Microsoft Word
  • Translate in Microsoft Excel
  • Translate in Microsoft PowerPoint

Show More

I once worked for an international company that was headquartered in Switzerland and have always been fascinated by languages and dialects. I enjoyed the frequent exchanges with Swiss colleagues who knew four or five different languages. Their emails gave me a tantalizing taste of another culture. I’m also half Italian and exchange frequent emails with Italian relatives.

When the person I’m emailing is more comfortable writing and reading in their native tongue than in English, I don’t let my own inability to write in that language slow me down. I simply use Microsoft Translator to translate my emails for them and their emails for me. Not only does it expand my view of the world, but it also gives me the chance to sharpen my Italian as I watch how Translator turns Italian into English and English into Italian.

If you want to translate text in Outlook emails, Word documents, Excel spreadsheets, or PowerPoint presentations, it’s easy to do. Maybe you work for an international company, like I did, or perhaps you communicate with colleagues or customers who are more comfortable writing in their native language. None of this is a problem for Office, which offers translation courtesy of an AI-powered Translator service that can translate a selection of text or an entire document, file, or message between many different languages.

The Translator service is accessible across multiple Microsoft products and technologies on the consumer and enterprise sides. Translator is integrated into Bing, Microsoft Office, SharePoint, Microsoft Edge, Skype Translator, and Visual Studio. Microsoft Translator is also available as an app for iOS/iPadOS, Apple Watch, Android OS, and Android Wear.

Translator supports more than 100 languages, including more common languages, such as English, French, Italian, Spanish, German, Chinese, Japanese, and Arabic, and some less common languages, including Fijian, Haitian Creole, Icelandic, Kurdish, Maltese, Serbian, and Ukrainian.

The accuracy of Microsoft Translator is evaluated using a BLEU (Bilingual Evaluation Understudy) score. This score measures the differences between a machine-based translation and a human translation of the same source text. One report from 2018 measuring Chinese to English translation gave Microsoft Translate a grade of 69 out of 100, which is a high score compared to human translation. This will likely improve with time, too, at least according to a Microsoft Translator blog post from November 2021 that explains how the company is working to advance its machine translation technology.

Now, here’s how to use the translator in the different Office applications.

Translate in Microsoft Outlook on the desktop

If you’ve purchased Outlook 2019 or later for Windows as a standalone app or as part of Microsoft Office or Microsoft 365, the translation functionality is built in. To set it up, click the File menu and select Options. In the Outlook Options window, select Language.

The window now displays your default display language for Office. Scroll down to the Translation section. Here, you can decide how to handle messages received in other languages, opting to always translate them, get asked before translating, or never translate. Next, select the target language if it’s not your default language. Then click the Add a Language button and select any languages for which you don’t want to see a translation.

How to translate emails, documents, and more with Microsoft Office (3) IDG

Close the Options window and return to the main Outlook screen. Open an email you want translated into your native language. Depending on the options you chose, the email will automatically be translated or give you the ability to have it translated. Either way, you should see a link in the message to translate the message to your language. If not, click the Translate button on the Ribbon and select the Translate Message command.

How to translate emails, documents, and more with Microsoft Office (4) IDG

Run the translate command, and the entire message appears in your native language. You can then switch back and forth between the translation and the original text and turn on automatic translation if it’s not already enabled.

How to translate emails, documents, and more with Microsoft Office (5) IDG

What if you want to take the reverse trip and translate an email you’re composing from your own native language to a different language? Unfortunately, Microsoft currently offers no reliable or workable way to do this in Outlook. The easiest workaround is to translate the text in Word, then copy and paste it into your message in Outlook.

Translate in Microsoft Outlook on the web

The translation service is also accessible for Outlook on the web. To set it up here, sign into Outlook with your Microsoft or business account. Click the Settings icon at the top right. In the Settings pane, click the link for View all Outlook settings. In the Settings window that pops up, select Mail and then Message handling. Scroll down to the Translation section and you’ll find the same settings as in the desktop version of Outlook.

How to translate emails, documents, and more with Microsoft Office (6) IDG

When you receive a message in a different language, the Translate feature will offer to translate it for you. Click the link to translate it. You can then switch back and forth between the original text and the translation.

As with the desktop flavor of Outlook, the web version presently offers no workable method for translating a new email from your own native language to a different language. Again, translating the text in Word is your best bet.

Translate in Microsoft Word

The translation feature in Microsoft Word works much the same way in the desktop and online versions.

Open a document that you want to translate, either in full or in part. Select the Review tab on the Ribbon. To customize the feature before using it, click the Translate button and select Translator Preferences. In the Translator pane that appears on the right, confirm that the switch is set to Yes for “Offer to translate content that isn’t in a language I read.” You can also add any languages that you don’t want translated.

If you only want certain text translated, select the text. Click the Translate button in the Ribbon and choose Translate Selection. In the Translator pane on the right, make sure the correct source language is detected. If it’s not correct, click the down arrow for the target language and change it. Hover your mouse over each word in the translation, and the feature will show you the translation just for that word. To add the translation to your current document, click the blue Insert button at the far right.

How to translate emails, documents, and more with Microsoft Office (7) IDG

Similarly, to translate the entire document, click the Translate icon in the Ribbon and select Translate Document. In the Translator pane, make sure the Document tab is selected. Confirm that the target language is correct. Click the blue Translate button at the far right. A new document is created and pops up with the complete translation.

How to translate emails, documents, and more with Microsoft Office (8) IDG

Translating from your own language to another works much the same way. Select the text you want to translate (or don’t make a selection if you want to translate the entire document), then click the Translate icon in the Ribbon’s Review tab and select either Translate Selection or Translate Document. In the Translate pane, set the target language in the To: field. Any selected text is automatically translated and appears in the pane. To translate a document, click the blue Translate button.

Translate in Microsoft Excel

The translation for Excel works only in the desktop version of the program. Select a cell or multiple cells that contain text you want translated. Click the Review menu and select Translate. In the Translate pane, make sure the source and destination languages are correct. You can then hover over each word to see its individual translation.

How to translate emails, documents, and more with Microsoft Office (9) IDG

To insert the translated text into a cell in your spreadsheet, select and copy the translation in the pane. Click the target cell and then paste the text.

Translate in Microsoft PowerPoint

As with Excel, translation for PowerPoint is available only in the desktop client. PowerPointcan translate selected text (not a whole presentation); it works just like translating selected cells in Excel.

PowerPoint also offers a handy feature that can translate your presentation as you speak it, which is great if you have an audience that is more comfortable in another language. The translations appear as subtitles as you deliver the presentation.

To get started, click the Slide Show menu and check the box for Always use subtitles. Then select Subtitle settings. In the web version of PowerPoint, click the Slide Show menu and select the down arrow next to Always use subtitles. Select or confirm the spoken language. Then select the subtitle language. Go back to the subtitle settings menu to choose where you want the subtitles to appear — overlaid on the bottom, overlaid on the top, above the slide, or below the slide.

How to translate emails, documents, and more with Microsoft Office (10) IDG

When you display the presentation as a slideshow, speak the words from each slide or from your own commentary. Subtitles for your spoken words will appear in the language you chose.

How to translate emails, documents, and more with Microsoft Office (11) IDG

Related:

  • Microsoft 365
  • Microsoft Office
  • Office Suites
  • Productivity Software
  • Artificial Intelligence
  • Natural Language Processing

Lance Whitney is a technology journalist and trainer with a background in IT. He’s written for a host of sites and publications, including CNET, TechNet Magazine, TechRepublic, PCMag, Macworld, AskWoody, Time, and AARP Magazine, and is the author of the books "Windows 8: Five Minutes at a Time" and "Teach Yourself Visually LinkedIn."

Follow

Copyright © 2022 IDG Communications, Inc.

It’s time to break the ChatGPT habit

I am Lance Whitney, a technology journalist and trainer with a deep background in IT. My experiences working for an international company headquartered in Switzerland have fueled my fascination with languages and dialects. Interacting with colleagues proficient in multiple languages and communicating with Italian relatives has given me a unique perspective on the importance of language in today's globalized world.

My expertise extends to Microsoft 365, particularly in leveraging its language translation capabilities across Outlook, Word, Excel, and PowerPoint. The article discusses how Microsoft's AI-powered Translator service seamlessly integrates into various Microsoft products, enabling users to translate text, documents, and messages between a wide array of languages.

The Translator service, evaluated using BLEU (Bilingual Evaluation Understudy) scores, supports over 100 languages, including common ones like English, French, and Spanish, as well as less common languages like Fijian and Kurdish. Microsoft's commitment to advancing machine translation technology is evident in their ongoing efforts, as highlighted in a blog post from November 2021.

Now, let's delve into the specific instructions provided in the article for translating text within Microsoft applications:

Translate in Microsoft Outlook on the desktop

For Outlook 2019 or later on Windows, access translation functionality through the File menu. Under Options, navigate to Language settings to configure how messages in other languages are handled. The Translator service is seamlessly integrated, allowing automatic or manual translation of emails.

Translate in Microsoft Outlook on the web

Outlook on the web offers a similar translation feature. Access settings, navigate to Message handling under Mail settings, and configure translation preferences. The Translate feature will automatically translate received messages in different languages.

Translate in Microsoft Word

In both desktop and online versions of Word, the translation feature is accessible through the Review tab. Customize preferences in Translator Preferences, and translate either selected text or the entire document. Translations can be added to the document with ease.

Translate in Microsoft Excel

Translation functionality in Excel is available only in the desktop version. Select cells containing text, access the Review menu, and choose Translate. Hover over words for individual translations, and insert translated text into cells.

Translate in Microsoft PowerPoint

PowerPoint, like Excel, supports translation only in the desktop client. Translate selected text, and PowerPoint offers the unique capability to translate a presentation in real-time as you speak. Subtitles appear in the chosen language during the presentation.

These instructions provide a comprehensive guide on leveraging Microsoft 365's translation capabilities, demonstrating the seamless integration of language translation services across various Office applications.

How to translate emails, documents, and more with Microsoft Office (2024)
Top Articles
Latest Posts
Article information

Author: Geoffrey Lueilwitz

Last Updated:

Views: 6490

Rating: 5 / 5 (80 voted)

Reviews: 95% of readers found this page helpful

Author information

Name: Geoffrey Lueilwitz

Birthday: 1997-03-23

Address: 74183 Thomas Course, Port Micheal, OK 55446-1529

Phone: +13408645881558

Job: Global Representative

Hobby: Sailing, Vehicle restoration, Rowing, Ghost hunting, Scrapbooking, Rugby, Board sports

Introduction: My name is Geoffrey Lueilwitz, I am a zealous, encouraging, sparkling, enchanting, graceful, faithful, nice person who loves writing and wants to share my knowledge and understanding with you.