Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this article, I will show you 2 easy ways on how to translate multiple cells in Excel.
How to Translate Multiple Cells in Excel: 2 Easy Methods
This is a sample dataset that I am going to use. There are some salespeople along with the zones they work in, order date, and the amount.
1. Use Built-in Translator in Microsoft Excel
The first method is to use the built-in translator in Microsoft Excel.
- Select the range you want to translate.
- Then, go to the Review.
- After that, select Translate.
- Excel will translate the cells.
Read More: How to Translate Language in Excel Formula
2. Use Google Translate to Translate Multiple Cells in Excel
The next method is to use Google Translate. It is a multilingual translation service created by Google with a view to translating texts, documents, and websites from one language into another. This will replace the words while translating.
- Visit Google Translate on your browser.
- Then, select Documents.
- After that, choose the languages. Here, I am going to translate the document from English to French.
- Then, select Browse your computer.
- After that, choose the file you want to translate.
- Then, click open.
- Google Translate will prepare the document for translation.
- Select Translate.
- Once the translation is done, download the file.
- Then, open the file. You will find the translation.
Read More: How to Use Google Translate Formula in Excel
Things to Remember
- The built-in feature will not replace the cells with the translated words. You have to do it manually.
In this article, I have explained how to translate multiple cells in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.