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

Get FREE Advanced Excel Exercises with Solutions!

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.

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

 


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

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.


Related Articles


<< Go Back to Translate in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo