How to Translate Text in Excel

This guide will show you how to translate text in Excel. The translate feature in Excel helps you to change content from one language to another right in your spreadsheet. This feature is handy globally where your data needs to be understood by people from various locations. When you are dealing with international business, working with multilingual data, or collaborating with teams in other regions, the Microsoft Excel’s translation tools make your work easier and faster.

Steps: How to Translate Text in Excel?

Step 1: Select the Cell or Range

• Select the cell where you want to use the Translator.
• You can also select the range of cells that you want to translate.

• In this example, click the cell B2.

Step 2: Navigate to Translate

• Go to the Review tab on the Ribbon and click Translate in the Language group.

• Alternatively, right click on the cell or the selected text and select Translate. The shortcut key for translate text in Excel is Alt + R + L.

Step 3: Select Translate To

• A Translator panel will appear on the right side of the Excel.
• It will auto detect the language you are translating from, but if you feel it is not correct then you can change it. You can also type the text or paste the text in this box.
• Select the language you are translating to within the drop-down list.
• The Excel will translate the text automatically within the spreadsheet. It will show the translations of the text on the below, based on word classes such as noun, verb, adverb, and adjective.

Step 4: Replace the Text

• Copy the text in the Translate To box and paste the in required cell, which you have translated.
• In this example, the text in cell B2 translated from English (Excel) to French (Exceller). So, copy the text Exceller and paste in cell B2.

What is the Shortcut key for Translate in Excel?

Below is the keyboard shortcut key to translate text in Excel:

Conclusion

The Translate in Excel lets you easily translate text directly in your spreadsheets. This feature helps you to save time and effort by letting you easily manage data in different languages.

Learn More