How to Translate Multiple Cells in Excel (2 Easy Methods)

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.


2 Easy Ways to Translate Multiple Cells in Excel

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.

Google Translate to translate multiple cells in excel


1. Use Built-in Translator in Microsoft Excel

The first method is to use the built-in translator in Microsoft Excel.

Steps:

  • Select the range you want to translate.
  • Then, go to the Review.
  • After that, select Translate.

  • Excel will translate the cells.

Built-in feature to translate multiple cells in excel

Read More: How to Translate Language in Excel Formula (with Easy Steps)


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.

Steps:

  • 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.

Google Translate to translate multiple cells in excel

  • After that, choose the file you want to translate.
  • Then, click open.

  • Google Translate will prepare the document for translation.
  • Select Translate.

Google Translate to translate multiple cells in excel

  • Once the translation is done, download the file.

  • Then, open the file. You will find the translation.

Google Translate to translate multiple cells in excel

Read More: How to Translate Excel File from French to English (2 Quick Tricks)


Things to Remember

  • The built-in feature will not replace the cells with the translated words. You have to do it manually.

Conclusion

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. Please visit Exceldemy for more useful articles like this.


Related Articles

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo